Answer;-
Transpose is the function which helps you to convert table from vertical to horizontal and horizontal to vertical form.
It is exist in Paste Special box in Home tab.
Working:-
1. Select the table and copy it.
2. Press shortcut on keyboard Alt+E+S and select transpose from here.
Thank You
Transpose is the function which helps you to convert table from vertical to horizontal and horizontal to vertical form.
It is exist in Paste Special box in Home tab.
Working:-
1. Select the table and copy it.
2. Press shortcut on keyboard Alt+E+S and select transpose from here.
Thank You
Dear All,
Thank you for your reply with correct answers.
Looking forward to have more detailed answers with example from your side on the questions which will be provided in the group
Thank you for your reply with correct answers.
Looking forward to have more detailed answers with example from your side on the questions which will be provided in the group
Some shortcut keys of MS Excel
Ctrl+A - Select All
Ctrl+B - Bold
Ctrl+C - Copy
Ctrl+D - Fill Down
Ctrl+F - Find
Ctrl+G - Goto
Ctrl+H - Replace
Ctrl+I - Italic
These shortcuts are related to formatting only.
Ctrl+A - Select All
Ctrl+B - Bold
Ctrl+C - Copy
Ctrl+D - Fill Down
Ctrl+F - Find
Ctrl+G - Goto
Ctrl+H - Replace
Ctrl+I - Italic
These shortcuts are related to formatting only.
Some shortcut keys of MS Excel
Ctrl+Tab - In a workbook: activate next workbook
Ctrl+9 - Hide rows
Ctrl+0 - Hide columns
Ctrl++ - Insert
Ctrl+- - Delete
Ctrl+Tab - In a workbook: activate next workbook
Ctrl+9 - Hide rows
Ctrl+0 - Hide columns
Ctrl++ - Insert
Ctrl+- - Delete
Forwarded from M.S. Office, Excel, PowerPoint, Word
⭕️⭕️Let us discuss 'Formats' option of paste special command.
Forwarded from M.S. Office, Excel, PowerPoint, Word
Forwarded from M.S. Office, Excel, PowerPoint, Word
⭕️⭕️This will help in a situation where you want to copy the formatting of one cell to other cells. Please use below steps: -
Forwarded from M.S. Office, Excel, PowerPoint, Word
Forwarded from M.S. Office, Excel, PowerPoint, Word
⏯Step 1: - Use Copy command on the range (Column H and Column I) of cells by using below shortcut keys: -
Ctrl + C: - Copy
⏯Step 2: - Come to “Column K” and Use any of below Shortcut key to show “Paste Special” window on screen: -
Ctrl + Alt + V
Alt + E + S
⏯Step 3: - Select “Formats” option and Press “OK”, other options should not be changed.
Ctrl + C: - Copy
⏯Step 2: - Come to “Column K” and Use any of below Shortcut key to show “Paste Special” window on screen: -
Ctrl + Alt + V
Alt + E + S
⏯Step 3: - Select “Formats” option and Press “OK”, other options should not be changed.
Forwarded from M.S. Office, Excel, PowerPoint, Word
Forwarded from M.S. Office, Excel, PowerPoint, Word
🎥🎥For Video trial please click on below link: -
https://youtu.be/BXyGREk6ICk
https://youtu.be/BXyGREk6ICk
Forwarded from M.S. Office, Excel, PowerPoint, Word
Dear Friends,
Please share your valuable suggestions and share this channel with your friends and please subscribe.
Thank you
Please share your valuable suggestions and share this channel with your friends and please subscribe.
Thank you
M.S. Office, Excel, PowerPoint, Word pinned «⭕️⭕️Let us discuss 'Formats' option of paste special command.»
Forwarded from M.S. Office, Excel, PowerPoint, Word
After having discussion on Lookup and Vlookup, let us now discuss one of the best function of Lookup Family ‘Hlookup’ with Approximate Match.
Syntax
=Hlookup(lookup_value, table_array, row_index_num, [range_lookup])
Important Note: -
1. ‘H’ stands for Horizontal lookup
2. Only works towards extracting data from the downside of the table.
Syntax
=Hlookup(lookup_value, table_array, row_index_num, [range_lookup])
Important Note: -
1. ‘H’ stands for Horizontal lookup
2. Only works towards extracting data from the downside of the table.
Forwarded from M.S. Office, Excel, PowerPoint, Word
♦️♦️In the screenshot you can see one problem is given in Table A and we need to find the Discount Percentage in Table B. We will solve this problem with the help of ‘Hlookup’ function. Please follow below steps: -
Forwarded from M.S. Office, Excel, PowerPoint, Word
☝️🟢Step 1: - Click on Cell ‘C13’ and press ‘=’ this will activate the cell to use function, and start typing ‘Hlookup’.
Forwarded from M.S. Office, Excel, PowerPoint, Word
✌️🟢Step 2: - After Typing ‘Hlookup’ start the function by using any one from below two sub-steps: -
(i) Press Start bracket ‘(‘.
OR
(ii) You can press ‘Tab’ button.
(i) Press Start bracket ‘(‘.
OR
(ii) You can press ‘Tab’ button.
Forwarded from M.S. Office, Excel, PowerPoint, Word
🤟🟣Step 3: - Select ‘Lookup Value in Cell C12’ as given in the syntax.
(Lookup Value is the value for which you want to find the result and based on this you can find the result from Table Array).
(Lookup Value is the value for which you want to find the result and based on this you can find the result from Table Array).
Forwarded from M.S. Office, Excel, PowerPoint, Word
✌️✌️🟢Step 4: - After selecting ‘Lookup Value in cell C12, select ‘Table Array from Cell C8 to M9’ from which you want to find the results of ‘lookup value’.
Forwarded from M.S. Office, Excel, PowerPoint, Word
🤟✌️🟣Step 5: - After selecting Table array please put koma (,) and the third field will reflect ‘Row_Index_Num’ means from which row you want to find the results, Type number 2 here.
(Explanation: - In this problem we have two rows in which data exist, and we want to find the Discount Percentage which is lying on 2nd row that is why we typed 2 here)
(Explanation: - In this problem we have two rows in which data exist, and we want to find the Discount Percentage which is lying on 2nd row that is why we typed 2 here)