Category: Shortcuts

How To Select All Cells From All Worksheets

December 3, 2020

In this article, I will show you how to select all cells from all worksheets. It sounds complicated but all it takes is just 2 simple steps. Expected Outcome Option 1: Select whole worksheet + Select All Sheets Step 1:

Excel Select Columns/ Rows To End Of Data

November 30, 2020

In this article, I am going to show you how to select column to end of data. I will provide you with 4 ways to deal with different situations.

Edit The Same Cell In Multiple Excel Sheets

November 24, 2020

Background Sometimes you will need to edit the same cell in more than one Excel worksheets. It is so time-consuming to change it one by one especially when your workbook contains more than 100 sheets. Do you have the following

Excel Unhide Column/Row Shortcut Not Working

November 23, 2020

Background Learned a new Excel keyboard shortcut but it doesn’t work on your computer? Or the shortcut used to work fine but it suddenly stops working? That could make someone really frustrated. Let’s say for example Ctrl Shift 9 /

10 Excel Ctrl Shift Shortcuts You Need To Know

November 23, 2020

Have you heard of these 10 Ctrl Shift Shortcuts in Excel? They are not as popular as other shortcuts but they are very powerful. Check out the table and demonstration to supercharge your productivity with Excel. Ctrl Shift Shortcut Usage

Select And Format All Subtotals Rows In Pivot Table

November 20, 2020

This is because you didn’t add the source data of the pivot table to the data model. Checking the box “Add this data to the data model” enables you to turn on distinct count feature in Excel pivot table.