Can anyone tell me how to turn the spreadsheet so that the columns are the rows?
	How do I rename sheets in my workbook?
	How do I find a specific worksheet in a workbook?
	How do I delete rows or columns in a worksheet?
	How do I adjust the column width on my worksheet automatically?
	Can I change the colors of my worksheet gridlines?
	How can I give my worksheet a polished appearance?
	How do I insert additional rows or columns in a worksheet?

Can anyone tell me how to turn the spreadsheet so that the columns are the rows?
Keywords: Transpose, Worksheets
Posted December 17, 1996

Sure, just follow these steps:

1. Add a new worksheet
2. Highlight all the data on your data worksheet and choose Edit - Copy
3. Switch to your new worksheet, select cell A1 and choose Edit - Paste Special - Transpose

The data will now be transposed on the new worksheet.

How do I rename sheets in my workbook?
Keywords: Rename Sheets
Posted March 31, 1996

The default names of the worksheets in your workbook are Sheet 1, Sheet 2, etc. For better organization, you might want to rename a worksheet with a descriptive title. To rename a worksheet in a workbook:

1. From the menu bar choose Format - Sheet - Rename
2. Write in the new name
3. Click OK

Other ways to access the Rename Sheet dialog box are:

1. Right-click on the sheet tab and select the correct command
2. Double-click on the sheet tab

How do I find a specific worksheet in a workbook?
Keywords: Find Worksheet
Posted February 8, 1996

When working in an workbook, you sometimes need to move back and forth to different worksheets. To do this you can scroll through your worksheet tabs.

A faster way is to utilize that oft-forgotten right mouse button. Find the VCR buttons in the lower left hand corner of your screen, just above the status bar.

Right click on any of the buttons.

A directory box of all the worksheets in your current workbook will display with the current worksheet checked. Then click on any of the worksheets listed and go directly to that worksheet.

If your workbook has more than 14 worksheets the last entry in the directory box will indicate More Sheets... Click on this and a list-style dialog box will allow you to display the remainder of your worksheets.

How do I delete rows or columns in a worksheet?
Keywords: Delete Rows Columns
Posted February 8, 1996

You can delete a row or column quickly in Excel. Select the row or column you wish to delete or use Shift+Spacebar to select an entire row; or Ctrl+Spacebar to select an entire column. From the menu bar, choose Edit - Delete or right-click on the mouse and choose Delete.

In some cases you will want to delete a single cell or range of cells only. Select the cell or range of cells you want to delete. From the menu bar choose Edit - Delete. Excel will then prompt you to indicate whether you want to Shift Cells Right or Shift Cells Down.

To clear only the contents of a cell, select the cell or range of cells. From the menu bar, choose Edit - Clear. Excel will then prompt you with the following options: All; Formats; Contents; Notes

Shortcuts: After selecting a row or column, use Ctrl+minus sign (-) to delete a row or column quickly. To delete the contents of a cell quickly, use the Delete Key or right-click on the mouse and choose Clear Contents.

How do I adjust the column width on my worksheet automatically?
Keywords: Adjust Column Width
Posted February 8, 1996

If you have long columns of entries of varying widths, it might take several tries before you get the right column width.

To avoid guesswork, select the column you want to adjust by clicking on header bar.

From the menu bar choose Format - Column - AutoFit

Shortcut: To quickly set the AutoFit width, position the mouse pointer at the right edge of the column header and double-click.

Can I change the colors of my worksheet gridlines?
Keywords: Gridlines Colors Change
Posted January 17, 1996

To change the colors of your worksheet gridlines, Select Tools - Options - View. Select a color from the Color drop down list under the Gridlines check box. Make sure the Gridlines check box is checked. Select OK. Your new colored gridlines are now applied.

How can I give my worksheet a polished appearance?
Keywords: Worksheet Appearance
Posted January 19, 1996

Shading titles, headings, and important results, gives your reports a polished and professional appearance.

To customize the pattern: From the menu bar choose Format - Cells - Patterns. The tab is divided into three sections:The Pattern drop-down box contains 18 cell patterns.

The Color box sets the background color. The Sample area shows how the currently selected pattern options will appear on the worksheet.

To apply a pattern to a cell or a range of cells, follow the above instructions and click OK or press Enter. Excel will return you to the worksheet with the patterns applied.

How do I insert additional rows or columns in a worksheet?
Keywords: Insert Rows Columns Worksheet
Posted January 18, 1996

The easiest way to insert a range into a worksheet is to insert an entire row or column. Select the row or column that will be after the inserted one. If you want more than one row or column, select that number of rows or columns.

From the menu bar, choose Insert - Rows or Insert - Columns. Excel then shifts the rows down and the columns to the right.

Shortcut: After selecting a row or column, use Ctrl+ plus sign (+) to insert a row or column quickly; or right-click on the header and choose Insert.

In some worksheets you will need to insert a single cell or range of cells and not change the surrounding data. Select the range of cells where you want the range to appear. From the menu bar, choose Insert - Cells. Excel will then prompt you to indicate whether you want to Shift Cells Right or Shift Cells Down.

Back to Top

Back to the FAQ Table of Contents

I'd explain it to you, but your brain would explode.