Entries Tagged 'format worksheets' ↓
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-22 06:00:59. 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-22 06:00:59. 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-22 06:00:59. 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-22 06:00:59. 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-22 06:00:59. 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-22 06:00:59. Republished by Blog Post Promoter
April 12th, 2010 — format worksheets
Need to make a table in Excel that includes the days of the week, or the months in a year? Let Excel handle that for you. 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-22 06:00:59. Republished by Blog Post Promoter
April 11th, 2010 — format worksheets
Open Microsoft Excel and you see worksheet gridlines, and labels that identify each row and column. Print Microsoft Excel and you may see nothing but the numbers themselves. No gridlines. No row and column headings. What happened? 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-22 06:00:59. Republished by Blog Post Promoter
April 11th, 2010 — format worksheets
Click the % (percent) toolbar button on a Whole number
Typing a number and clicking the % toolbar button is the same as multiplying that number by 100 and adding a percent symbol behind it.
Enter the number 10, and then click the % toolbar button on that cell. The number turns into 1000%.
Click the % (percent) toolbar button on a Decimal number
In another cell, type the number .10 (decimal in front of the 10). Click the % toolbar button on that cell. The number quickly turns into 10%, not 1000%.
Keep in mind the results when converting whole and decimal numbers to percent numbers with the % toolbar button .
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-22 06:00:59. Republished by Blog Post Promoter
April 10th, 2010 — format worksheets
A Dollar is a Dollar? Not with Excel.
Type the following numbers in a column: 1000, 2000, 3000.
Change the number 1000 to Currency format:
Format -> Cells -> Currency -> OK
Change the number 2000 to Accounting format:
Format -> Cells -> Accounting -> OK
Now, change the column width to 12:
Format -> Columns -> Width -> 12 -> OK
Notice the $ symbol before the number 1000 is next to the first number, while the $ symbol before the number 2000 is not next to the first number, but next to the left-cell border.
Now, here is the twist. The Currency format category in the Format Cells dialog box is not the same as the Currency Style on the Formatting Toolbar.
Click on the number 3000, then click the $ symbol on the Formatting Toolbar. The $ symbol is next to the left border of the cell, which is the Accounting format. Go figure. Kind of like finding the Shutdown command in the Start button.
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-22 06:00:59. Republished by Blog Post Promoter