Working in a workbook part III

Grouping sheets for Editing, Formatting: -

Excel gives you a great flexibility of formatting or reorganizing of your grouping sheets in workbook. That means if you have to same formatting on your three sheets then you don’t want to format the three sheets individually. You can format the three sheets simultaneously for this you must be known about the grouping of sheets. So our today’s matter of discussion is grouping worksheets.

To select a group of sheets, do this;
1) Select the first sheet tab
2) if you want to select the sheets in a adjacent then press and hold down the Shift button on your keyboard and then click on the last sheet tabs in the group the you seen the all sheet tabs between the first and the last sheet become on a group including the same. If you want to select non adjacent sheets then select the sheet first and press and hold down the Ctrl key on the keyboard and click on the other sheet, do this for each sheet tab you want to select.

To select all the sheet tabs point you mouse to the sheet tab and right click of mouse from the shortcut menu click on the Select all sheets….

Scrolling with your keyboard in Excel: -

You also know about how to scroll in Excel with your keyboard. If you think that is like moving or select a cell with you keyboard then you wrong.
For scrolling with the keyboard; do this:
To avoid change your cell selections press the Scroll Lock button on your keyboard. And then you are ready for scrolling with the key combination or individual key the list of key given following.

Key Movement direction

Up Scrolls up to one row.
Down Scrolls down one row.
Left Scrolls left one column.
Right Scrolls left one column.
PgUp Scrolls up one screen.
PgDn Scrolls down one screen.
Alt+PgUp Scrolls right one window.
Alt+PgDn Scrolls left one window.
Home Moves to the beginning of the row.
Ctrl+Home Moves to the beginning of the worksheet.



Using Go Command to move or select a cell (F5);

Hi friend this is my next lesson. I want that any person who read this blog he could understand my blog. That is not a matter he is a beginner or master in Excel. I am also trying to give you all tips.

To use the Go to command; do this:

1) Click the Edit menu and choose Go To ……or press F5. Or press Ctrl+G. The Go to dialog box appears.
2) In the Reference text box, type the cell address or range you want to go to, or select from the Go to: list box the Named location Click OK or press Enter.
3) Click Ok or press Enter.


Tips: - If you want to see the active cell, but you unable to see it in the excel window, press Ctrl+Backspace, the window scrolls to show the active cell.

Working in a Workbook part II

Let’s start our continuous lesson.

Copying and moving worksheets: -

Suppose that you using a worksheet in a workbook and the same worksheet and data also required for another workbook, and then you have two choices that you create a new worksheet as it is or you can copy the worksheet from your previous workbook. I think the second option is much easier than first once, what you think?

To copy/move a sheet, in the same workbook; do this:

1) By your mouse select the sheet which you want to copy or move.

2) Now if you want to copy within the same workbook, press and hold down Ctrl key and drag the sheet tab to its new location. A copy of the sheet is formed in the new location with a logical name of new sheet tab.

3) How ever if you want to move the sheet within the original workbook drag the sheet tab to the location where you want to move the worksheet. Your sheet tab changed its position from old to new position.

Copy/move between workbooks; do this:

1) Open the both workbooks which are to be used.

2) Click on the Windows menu from the menu bar then select Arrange. Select desired arrangement, Example: - Tiled, etc.

3) To copy press and hold down the Ctrl key then select the sheet tab which you want to copy and dragging it to the new workbook in which place you want to copy it.

4) To move sheet between workbooks, Select the sheet tab and drag it to the new workbook to its new location.

For copy/move through menu command; does this: -

1) Open the both workbooks.

2) Activate the workbook from which you want to copy/move the sheets click the edit menu from the menu bar and then select Move or copy sheet…. a dialog box is appear.

3) Choose you choice.

4) From the To book: in drop down list select the name of the workbook where you want to move/copy the worksheet. If you want to move the sheet in a new workbook select new workbook.

5) In the before sheet: select the name of the sheet before which you want to insert the sheet.

6) Press the ok button

Note: - alternatively you move/copy your sheet by right click of your mouse over the sheet tab which you want for the same then select move from the shortcut menu.

Bookmark this post:

Working in a Workbook Part I

Hi Friends how are you; I know that I am come back after a long time, I am extremely sorry for this incontinence.

Today I am ready for written about how to work with a work book.

Let start to use a workbook for manipulating data stored in various worksheets.

Moving between worksheets: -

Now I think all of you could understand about workbooks. Actually when you are open a excel file (example: - “.Xls”, “.CSV”, etc) that means you open a workbook which contain multiple sheets. In Excel you can open multiple workbooks so you must be known about how to move between worksheets easily. First thing which you must be known that for working with a work book you must be activate the Workbook.

To activate an opened workbook, do this:

1) From the menu bar select the window menu

2) Then from the list of opened window select the name which you want.

To activate a window by shortcut menu, do this:

1) Press the combination key of Ctrl + F6 and switch between open workbooks easily.

Inserting and Deleting Sheets: -

When you starting working with a workbook you will want to insert or remove sheets as per your requirement. Excel gives you a great flexibility to insert or remove sheets.

Inserting a sheet: -

You can insert a new sheet in the workbook at any location you desire.

To insert a sheet in to your work book, do this:

1) Activate the workbook you want to insert a sheet

2) Select the sheet before which you want to insert a sheet by clicking its sheet tab

3) Click on the insert menu and choose the Worksheet.

To insert a sheet in to your workbook by shortcut key, do this:

1) Activate the workbook by pressing the key combination of Ctrl + F6

2) Then by pressing Ctrl +PgDn or Ctrl + PgUp select the sheet tab before which you want to insert the sheet

3) Then press Shift + F11 to insert a sheet.

Deleting a sheet: -

To delete a sheet from a workbook; do this:

1) Select the sheet you want to delete

2) Click the Edit menu then choose Delete Sheet from it.

Another option is take the mouse pointer on the sheet tab which sheet you want to delete click the right mouse button and then choose delete.

Change the number of sheet in new workbooks:

To change the no of sheet in new workbooks; do this:

1) Click Tools menu then choose Options. A new dialog box is opened which is called option dialog box.

2) Select the option tab from this.

3) Select the Sheets in a workbook: and choose the number of sheets in a workbook.

4) After you set the number of sheets then press OK button.

Note: - A workbook contains 3 sheets in default