Monthly Archives: January 2012

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 2011-02-02 07:29:35. 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 2011-02-02 07:29:35. 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