Excel Shortcut Keys for Intermediates

3. Go to Next or Previous opened Workbooks: -

• Next workbook: - To move to next opened workbook then press Ctrl + Tab key (Windows) and Control key + Tab(Mac).
• Previous workbook: - To move to previously opened workbook then press Ctrl + Shift + Tab key (Windows) and Control key + shift key + Tab (Mac).

4. Find Next and Previous match after using find option: -

• Next Matched value: - Use shift +F4 to find next matched value.
• Previous Matched value: - Use Ctrl + Shift +F4 to find previous matched value.

5. Create a Chart and Embedded chart: -

• Create Chart: - Create a new chart in the new worksheet of selected data or whole data from the active worksheet.
• Create an Embedded Chart: -Create a new chart within the worksheet of selected data or whole data from the active worksheet.

6. Change the format of value to number time, date, currency, and percentage: -

7. Edit cell format, Bold, Italic, Underline and Strike-through Formats: -

8. Auto-sum selected cells and select function: -

• Auto-sum of selected cells: - If you want to make a total of selected value then use this shortcuts after selecting your data in a column and you will get total of all value below the last selected cells.
• Select the function from below shown suggestion: - When you are trying to using the function of excel then excel by default show you some suggestions like if you press sum after + or + then excel will show you the options like sum, sumif, sumifs, sumproduct etc. you can select any one from them by using down or up arrow key when the function is highlighted then press tab key.

Command to	Window shortcut	Mac Shortcut
Auto-sum of selected cells	Alt + =	Command Key + 1
Select the function from below shown suggestion	Tab	+ Tab

9. Insert Today Date and Current Time: -

10. Expand and collapse Ribbon and Activate access keys: -

• Expand and collapse Ribbon: -If you want to show more rows on your worksheet or you don't want to show ribbon and you can use this shortcut key to expand and collapse the ribbon.
• Activate access keys: - If you want to access all ribbon functions then use this key it will highlight all function with the alphabets and then press highlighted alphabet and you can select the function from ribbon without using a mouse.

Thanks for reading the topic of "Excel Shortcut Keys for Intermediates".