excel

Thu
01
May
Dennis Faas's picture

Multiple Sheet Selections in MS Excel

Many times you make the same changes to multiple sheets in an Excel Workbook. Perhaps you would like to change the column widths or apply special formatting to a range of cells in several sheets. Creating a group of selected sheets allows you to ... perform the task just once, thereby saving time and narrowing the margin for errors. There are several ways to select several sheets to create a multi-sheet selection: To select contiguous sheets, follow the steps below: Click a sheet tab. Click Shift and keep it depressed while clicking a second sheet tab. Excel will select both clicked sheets and ... (view more)

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
26
Mar
Dennis Faas's picture

Cancel a Command in MS Excel

How many times have you started to perform an operation or action within Excel, when you decided half way through that you wanted to cancel it before it finished? Well the good news is that it is not impossible to do this, and it's not even ... difficult at all either! Usually all that is necessary is to simply press the Esc key. This one little key stroke should cancel any command or action that Excel is processing at that instant. It isn't very well known, but you can also press Esc to close almost any dialog box that may pop up in MS Excel. When you become a member at CarolsCornerOffice.com, ... (view more)

Mon
24
Mar
Dennis Faas's picture

Changing Excel's Starting Date

MS Excel will allow you to select which date you use as the beginning point for serial numbers. In Personal Computers, this date is January 1, 1900. Excel workbooks imported from the Macintosh environment require you to set the starting date to ... January 2, 1904--the date used on the Mac. To set these two dates, follow the steps below: Click on Tools | Options. MS Excel will display the Options dialog box. Make sure the Calculation tab is selected. The 1904 Date System check box controls which dating system is used. If the check box is not selected, then the January 1, 1900 starting date is ... (view more)

Tue
22
Jan
Dennis Faas's picture

Microsoft Reveals Excel Security Risk

Microsoft has warned that several older versions of Excel contain a bug that could be exploited by hackers. It affects both Windows and Macintosh users. The bug could make it possible to execute code remotely. That means a hacker would be able to ... gain some degree of access to a user's computer, with the potential to steal personal information. The problem affects versions of Excel (including the stand-alone viewer) dated up to and including 2004. However, if the user has downloaded Office Service Pack 3, the bug will have been removed. Those versions dated 2007 or 2008 do not have the bug. To ... (view more)

Tue
22
Jan
Dennis Faas's picture

Excel Status Bar Calculations

You do not always need a formula in MS Excel. That's right, you can just look at the Status bar to view a quick calculation. On the right-hand of the Status bar, at the bottom of the Excel screen, calculations can be displayed for the average, ... count, number or numbers, maximum/minimum value, and sum of any given range of numbers. Follow the steps below to see how: Select a range of cells in MS Excel. In Excel version 2003, right-click on the Status bar, where you see the calculation listed, and choose the function to be performed. In Excel version 2007, look toward the bottom of your screen. ... (view more)

Mon
17
Dec
Dennis Faas's picture

Add Autonumbering to your MS Excel Spreadsheet

Autonumbering will advance your numbered rows and keep them current, even if you should delete or add a row. Unfortunately, MS Excel does not ship with an autonumbering feature (like that found in MS Access), that increments a number each time you ... add a new row. In Excel 2003 and 2007 however, you can use the Row function to add your own autonumbering to a list. Say you want to create a list of all of your school's classes and their corresponding learning materials. Follow the steps below to add autonumbering to the list: In A1, enter the formula below: =TEXT(Row(A1),"000-000") Enter the name ... (view more)

Mon
01
Oct
Dennis Faas's picture

Changing Directions In MS Excel

The default behavior of the Enter key drives some Excel folks crazy. When you press Enter, some users would prefer that the cursor to move to the next cell on the right, while other folks prefer the cursor to move down. Fortunately, MS Excel can ... accommodate these preferences and more. To change the way Excel reacts after Enter is pressed follow the steps below: Go to Tools | Options. Select the Edit tab. Click the Move Selection After Enter checkbox to activate the Direction drop-down list. In the drop-down list, select from the following options: Down Right Up Left If you prefer that the ... (view more)

Tue
28
Aug
Dennis Faas's picture

Adding Times in MS Excel

You can add times in MS Excel using the =SUM worksheet function. All you have to do is enter all of your times as HH:MM:SS, and then use SUM to add them. You may omit the :SS if you like. By default, Excel will display the sum of times in ... time-of-day format, such that adding 12:30 + 12:45 will give you a total of 01:15. You can prevent MS Excel from rolling over at twenty-four hours by formatting the total cell as [h] :SUM, which will cause the total to display as 25:15 rather than 01:15. Another way of adding times is to use the TIME function. Follow along below: To add 2 hours, 30 minutes ... (view more)

Mon
13
Aug
Dennis Faas's picture

Keep MS Excel From Automatically Updating Charts

Sometimes it seems as though Microsoft Excel is almost too efficient. For instance, Excel will automatically update a chart when you make a change to the chart data. If you need to capture a screenshot of your chart before a change is made, you need ... to break the link to its data source. Follow the steps below to prevent MS Excel from automatically updating your charts: To keep Excel from automatically updating a copy of a chart with new data, you need to break the link to the source data. Launch MS Excel if it isn't already open. Copy the chart that you do not want to be automatically updated ... (view more)

Pages

Subscribe to RSS - excel