Wednesday, January 16, 2019
Home Tags Worksheet

Tag: worksheet

How to select Cells in a Worksheet

There are many ways to select cells in a worksheet. In this post we will demonstrate the most commonly used methods to select cells. Select a single cell within the worksheet and then use Ctrl + A and all cells will be selected. If the cell selected contains data then the Ctrl + A selects the region containing the data. Pressing Ctrl + A again will select the entire worksheet.

Unhide Multiple Worksheets

Have you ever received a workbook from that has multiple hidden worksheets. The standard approach within Excel is to right click on the worksheet names and select Unhide. Then you need to select one worksheet at a time to unhide. If there are many worksheets this can take forever.