worksheets

Thu
17
Apr
Dennis Faas's picture

Spell Check All Your Worksheets in your Excel Workbook

I bet that a lot of you were not aware that when you run the Spell Check feature in MS Excel, it only checks the instant worksheet and not the others in your multiple worksheet workbook. No? You didn't know that? Well then I am glad that I have now ... brought it to your attention! So now that you are aware of this I will proceed to tell you how to make Excel check all of the worksheets in your workbook. Follow the steps below to learn how: Select all the worksheets before you run the Spell check! That was quick and easy wasn't it? What? You don't know how to do that? Ok, I will show you! Right- ... (view more)

Wed
23
May
Dennis Faas's picture

Linking Files: MS Excel

Data that is stored in one section of a worksheet is often needed in other sections of the same worksheet, other worksheets within the same workbook, or even different workbooks. Excel makes it easy for you to create dynamic or active links between ... cells, whether they are in the same or different workbooks. Linking data eliminates the need to repeat information in several files. Links are often used to automate worksheets that share similar values. For example, several worksheets might use an interest rate figure that is constantly changing. Instead of updating the interest rate in each ... (view more)

Wed
16
May
Dennis Faas's picture

Working with Multiple Worksheets in MS Excel 2007

Working with multiply sheets concurrently is how MS Excel power users create and format a complex workbook with the least amount of effort expended. Follow the steps below to make working with multiple sheet a piece of cake and you will be on your ... way to becoming a power user! Hold down the CTRL key as you click each tab top select multiple worksheets. To select a contiguous group of worksheets, click the first one in the group and then hold down the Shift key and click the last one in the group. To select all the worksheets in the current workbook, right-click any worksheet tab and choose ... (view more)

Wed
25
Apr
Dennis Faas's picture

Working with Excel 2007 Worksheets and Workbooks

Each new Excel workbook starts out with three blank worksheets, and an index tab at the bottom of each worksheet identifies the sheet by name. You can add a new worksheet or delete an existing worksheet and rename or rearrange worksheets to suit ... your whim. A fourth tab is the Insert Worksheet tab. Click it and a new worksheet is created instantly as well as a fifth Insert Worksheet tab that appears just in case you want to keep adding worksheets. In Workbooks with many worksheets, you will not be able to see all the sheet names without using the four arrow buttons to the left of the sheet ... (view more)

Subscribe to RSS - worksheets