Worksheet manipulation

The data we enter and process is often found in multiple spreadsheets. Depending on the version of Excel you’re using, after starting the program, each new document has one or more worksheets present. The number of worksheets appearing in each new document can be set in general options, and users can add, delete, move, change color or name of the worksheet on their own. The redistribution of the table on the worksheets can help you get a lot more organized.

As most of you already know, each worksheet is represented by a tab, and the workbook tabs are located in the status bar at the bottom of the window. Selecting a specific worksheet is done by clicking on the desired tab. By combining the click and the CTRL key, we can select multiple worksheets. Also, by clicking on the first worksheet, and then repeating the click while holding down the SHIFT key, we will select all worksheets between the first and last, including them. If there are multiple worksheets in the document, we can move from one to the other using the CTRL + PGUP key combination (previous worksheet) and CTRL + PGDN (the next worksheet). If this is the case, and the SHIFT key is simultaneously selected. The deselecting worksheets is done by clicking on the first free worksheet.

If you select multiple worksheets at the same time you can simultaneously import content into all of them, which, you will agree, can sometimes be very useful. For example, if we select three worksheets and then enter a value in cell A1, the value of this cell will be the same in all three worksheets.

We add a new worksheet by clicking on the icon with the “+” symbol to the right of the last worksheet or by pressing the SHIFT + F11 key combination. If we have previously selected a data table, clicking on the F11 button will insert a new worksheet to the chart and automatically create a graph based on the given data. By combining the CTRL + F11 key, quick macros are created.

Right-clicking on one of the worksheets opens a context window that displays the options for manipulating the worksheet. Here is a brief description of some commonly used options:

• Insert – this opens a dialog window in which we choose whether we want to insert a regular worksheet or a special worksheet (chart, macro, form, template, etc.)
• Delete – this option allows us to delete an active worksheet.
• Rename – after adding a new worksheet, it automatically gets a name that consists of a „Sheet“ word and a new sheet number. This option allows us to change the name to the worksheet so that it focuses more on the data or reports it contains.
• Move or Copy – opens the dialog box for moving or copying the current worksheet. The dialog window first offers us to choose whether to move or copy to one of the existing or new workbooks, and in front of which worksheet we want to move or copy the current worksheet. At the bottom of the window there is an optional field that, if indicated, indicates that we are copying and if the worksheet is not moved.
• Tab Color – by clicking this option, a menu opens in which we can select the color of the worksheet card.
• Hide / Unhide– These options are used to hide the current worksheet or detect one or more hidden worksheets.
• Select All Sheets – by activating this option, we will select all existing worksheets