Format worksheets

Zeroes Entered after Decimals

February 19, 2012
By

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. Read more »

Related Articles:

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

Page Break Preview

February 18, 2012
By

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? Read more »

Related Articles:

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

Group Tabs Together

January 31, 2012
By

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.

Related Articles:

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

Another Way to create a range of Dates in a Row or Column

January 21, 2012
By

Using the date of this message, January 23, 2011, type 23-Jan-2011 in a cell. Do not use the Enter key yet

In the Editing group of the Home tab, click the Fill button, then click Series. The Series dialog box opens to show 3 sections labeled Series in, Type, and Date unit.

In the Series in section, choose either the Rows or Columns button.

If you choose Rows, the range will be displayed along a row.
If you choose Columns, the range will be display in a column.

Put 6-18-2011 or 6/18/2011 in the Stop value box.

Click the OK button. Now you can change the date to include the name of the month, display slashes or dashes, etc.

Practice dates that are seven days apart within a month (once a week), every other Monday, etc.

Related Articles:

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

Type a Fraction, get a Date!

December 12, 2011
By

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.

Related Articles:

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

Archives

Tags

accounting format AutoAum AutoFill AutoFit Columns close Excel column border columns not wide enough Context menu copy cells currency format currency style cursor cut and paste cells date dates Drag and Drop edit Edit menu fill series format numbers formulas fractions Functions Keyboard shortcuts mouse pointer move sheet tab move worksheet normal view numbers open Excel page break view pound symbol print active worksheet print entire workbook print list print row and column headings print selection print titles randbetween random numbers save Excel set print area sum function the " # " symbol turn on gridlines