Want To Manage WorkBook Easily?

If you aware about Excel file structure, the workbook handling task would become very easy. How a normal textbook has its name and number of pages within it, a Workbook also has a title and number of worksheets within it.

You can see worksheets in the sheet tab, which is just above the status bar. The default number of worksheet in a Workbook is three. Using the following path you can customize the number of worksheets to be opened every time when you create a new file.

Tools => Options => General tab => Sheets in new workbook and change the number.

Inserting worksheets:

To insert an additional worksheet, follow any one of the options below:

1. Press Shift and F11 key at a time.
2. Select ‘Insert worksheet’ from Insert Menu
3. Keep your mouse on sheet tab, which is above status bar and right click the mouse. A pop-up menu appears. Select ‘Insert’ from the pop-up menu. (Recommended option)

Tip: Using this pop-up menu option, you can even insert multiple worksheets. Hold shift key to select many worksheets and select ‘Insert’ from the pop-up menu.

Move or Copy Worksheets

Worksheets can be moved within workbook. It can also be moved to an existing workbook or a new workbook.

To move a worksheet, follow any one of the options below:

1. Select ‘Move or Copy’ from Edit menu.
2. Drag the sheet directly into the desired location.
3. Keep your mouse on sheet tab, which is above status bar and right click the mouse. A pop-up menu appears. Select ‘Move’ from the pop-up menu. (Recommended option)

A dialog box appears now. You need to choose the exact location where you want to move. Use ‘To book’ drop menu if you like to move it to an existing worksheet or a new worksheet.

Tip: To make a similar copy of worksheet please enable the option ‘Create a copy’ in the dialog box.

Info: Always save your workbook before performing this command.

Delete Worksheets

A workbook must have minimum one worksheet. Keeping any one worksheet available in the workbook you can delete one or more number of worksheets.

To delete a worksheet, follow any one of the options below:

1. Select ‘Delete sheet’ from Edit menu.
2. Keep your mouse on sheet tab, which is above status bar and right click the mouse. A pop-up menu appears. Select ‘Delete’ from the pop-up menu. (Recommended option)

Tip: Using this pop-up menu option, you can even delete multiple worksheets. Hold your shift key to select many worksheets and select ‘delete’ from the pop-up menu.

Info: Remember deleted sheets will be lost and unrecoverable so always save your workbook before performing deleting operations.

Hide and Unhide Worksheets

You can hide a worksheet if you do not like to keep it in display. You can unhide it whenever you want. Click ‘Format’ Menu, click ‘Sheet’ submenu and find Hide or Unhide options.

Info: Worksheets that are hidden by Visual Basic program cannot be Unhide by this method. We will discuss soon how to unhide a workbook that is made hidden by visual basic program.

Want To Know How To Work With COMMENTS?

While working with Excel it may be necessary to brief at times why the value went up or down. In some places you may want to write some hints about the value for your own reference text. But such references will lead lot of rework while preparing instant reports. Moreover you may not like if they are visible to everyone. Microsoft Excel allows you to create short notes on each cell using a command Comment.

You can find the command in the Insert menu. You can even find it in the pop-up menu. The pop-up menu opens either right clicking your mouse or by pressing Shift key and F10 key at the same time.

Tips: By pressing Shift key and F3 key, you can directly create comment and start writing your note. You can customize the text box size, font, font size and its location. You need to type the text and press enter

You will find a red mark now on the top right corner of the cell. While moving mouse pointer nearer to the cell, Excel displays comments whatever you typed just like the above pictures.

Let us know how to manage these comments now.

To edit a comment use Shift Key and F3 function key at the same time.

You can even do by opening the pop-up menu and selecting ‘Edit Comment’ option to make necessary correction. Select ‘Delete comment’ option to delete the existing comment. Select ‘show comment’ option to keep displaying the comment in the screen.

There is a tool bar specially meant for working with comments. You can activate it by selecting comments from View menu.

Info: Always ensure that comments are not disabled in your Excel environment settings. Otherwise you may not able to see any comments even you create.

You can check the current settings for comments from the following path.

Excel => Tool menu => Options => View Tab => Comments => Comment indicator only.