June 25th, 2010 — type or insert cells, rows and columns
The first time a new student enters a fraction in a cell, the number changes into a date. If you know you will be entering a series of fractions in a worksheet that will be used in calculations, change the cell format to recognize those values as fractions instead of text. Here is how to make that change. Continue reading →
Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.
Originally posted 2010-02-24 06:00:10. Republished by Blog Post Promoter
June 23rd, 2010 — format worksheets
Entering numbers followed by a decimal with trailing zeros will not immediately display the zeros. The default format for a number is the category called Number that does not display decimal. Here’s how to display zeros in a cell. Continue reading →
Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.
Originally posted 2010-02-24 06:00:10. Republished by Blog Post Promoter
June 23rd, 2010 — format worksheets
A common question I receive about Microsoft Excel is “How do I know when I am near the bottom of the spreadsheet, and where is the right margin of the spreadsheet? Continue reading →
Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.
Originally posted 2010-02-24 06:00:10. Republished by Blog Post Promoter
June 5th, 2010 — format worksheets
Group Tabs Together To Perform A Task Across The Group
You have three worksheets that will have the same column headings and/or the same row headings/labels. The only thing that will change are the numbers. So make it easy for yourself. Make the column headings and row labels of all three worksheets at the same time.
Open Excel. The three worksheets are displayed and labeled as Sheet1, Sheet2, and Sheet3. The active worksheet is Sheet1. Inactive worksheets are displayed as tan-colored tabs. Hold down the Ctrl key and click on Sheet2 and Sheet3.
In column A, type the numbers 1 through 5 in each cell of that column. In cells B2, C2, D3, E3, and F3, type the first 5 letters of the alphabet (A B C D E). Now, click on Sheet2 and Sheet3. You’ve typed into three different worksheets at the same time, with the same information.
Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.
Originally posted 2010-02-24 06:00:10. Republished by Blog Post Promoter
April 27th, 2010 — edit worksheets
Many students over time have asked me the reason for the location of the Microsoft Office Excel 2003 commands that Insert or Delete a row or column of cells. Using the Insert menu to add a row or column makes sense. A new user sees the Insert menu, clicks it and find the options to insert a cell, row or a column as the top three commands of the Insert menu. Makes good sense. But if you want to delete a cell, row, or column, you would think that there would be a Delete menu, right? Wrong. The command to delete a row, or a column is in the Edit menu. And you don’t delete a cell by itself. Go figure!
To maintain a resemblance of consistency in using these commands, I show students how to use the context menu, commonly referred to as the right-click or shortcut menu. They select a range of cells, right-click inside the block of cells, and choose the Insert and Delete commands. I also note to the students that these commands, along with other commands that have the ellipse, the three dots ( … ) that follow a command, indicating a command contains another menu with more options to choose. In this case, the options contain the Insert and Delete commands and the options to insert or delete a row or column.
If you get frustrated trying to find the commands to add or remove a row or column, see how easy it is just to select a block of cells, right-click the cells and add or removed them from a worksheet.
Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.
Originally posted 2010-02-24 06:00:10. Republished by Blog Post Promoter
April 15th, 2010 — format worksheets
You want to type a fraction in Excel, but always get a date. How do you break this date?
The easy way is to put a ‘0’ (zero) and a space, in front of the fraction.
But what if you are typing a long row or column of cells with fractions. It’s time-consuming to put zeroes in front of each fraction. What to do?
- Select the cells you want to change
- Click Format from the Menu Bar
- Click Cells
- Click the Number tab, and then in the Category: window, select Fraction
- Click the OK button to accept this display change.
Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.
Originally posted 2010-02-24 06:00:10. Republished by Blog Post Promoter
April 14th, 2010 — edit worksheets
New users have asked me, what is the difference using formulas to calculate a total, or using the AutoSum function. Convenience! Continue reading →
Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.
Originally posted 2010-02-24 06:00:10. Republished by Blog Post Promoter
April 14th, 2010 — print worksheets
After you enter data into your Excel spreadsheet, it’s time to print it out. You click the Print command. It displays a dialog box with a section labeled Print What. You think the answer is obvious! Print the information I just entered, right? Not so fast. Continue reading →
Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.
Originally posted 2010-02-24 06:00:10. Republished by Blog Post Promoter
April 13th, 2010 — format worksheets
The Currency toolbar button ( $ ) in Excel 2003 and 2007 will not display a number the same way as the Currency category in the Format Cells dialog box. Continue reading →
Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.
Originally posted 2010-02-24 06:00:10. Republished by Blog Post Promoter
April 13th, 2010 — format worksheets
Why are pound symbols (#####) in my cells? Continue reading →
Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.
Originally posted 2010-02-24 06:00:10. Republished by Blog Post Promoter