Posts Tagged ‘row’

« Older Entries

Adjust Column Width and Row Height in MS Excel

Monday, February 6th, 2012

This may seem to you to be a very basic tip but there are always folks out there who can benefit from this information and this is for them!

  1. To adjust your column width, select the column you want to adjust and simply drag the vertical bar between any two columns to the width that suits you.
  2. You can also double-click that same vertical bar and the columns will automatically fit to the widest entry in each column.

The same applies for adjusting row height in Excel.

  1. Select the rows you want to adjust and drag the horizontal bar between any two rows to the desired row height. If you double-click on that same bar, Excel will automatically adjust the rows to the best fit.
  2. If you want to have your column width adjusted based ont he widest entry in part of the column, select the area where you want the column width based on and click on Format | Column | AutoFit Selection.

Tags: , , , , , , , ,
Posted in Excel 2003, Excel 2007, Excel 2010, Microsoft Office Excel | No Comments »

Unhide Hidden Rows or Columns in MS Excel

Thursday, December 10th, 2009

I have, on occasion, become the recipient of an MS Excel workbook that has hidden rows or columns. Mind you, it doesn’t happen often but when it does it can be a real problem because I don’t always remember how to unhide them and as you all know, I hate wasting time floundering around trying to find a resolution.

Follow the steps below to learn how to unhid rows and columns:

  1. Highlight the row above and the row below the hidden row(s), or the column to the left and right of the hidden column(s).

There are a couple of methods to reveal the hidden rows and columns:

  • Click on Shift + Ctrl + zero.
  • Right-click your selection and select Unhide.
  • Click on Format | Column (or Row) and select Unhide.
  • In version 2007, in the Cells group on the Home tab, clcik Hide & Unhide and select Unhide Rows or Unhide Columns.

Very simple eh?

Tags: , , , , , ,
Posted in Excel 2003, Excel 2007, Microsoft Office, Microsoft Office Excel, Office Productivity | No Comments »

Add AutoNumbering to your MS Excel Spreadsheet

Thursday, February 26th, 2009

Autonumbering will advance your numbered rows and keep them current, even if you should delete or add a row.

Unfortunately, MS Excel does not ship with an autonumbering feature like that found in MS Access, that increments a number each time you add a new row. In Excel 2003 and 2007 however, you can use the Row function to add your own autonumbering to a list.

Say you want to create a list of all of your school’s classes and their corresponding learning materials.

Follow the steps below to add autonumbering to the list:

  • In A1, enter the formula below:

=TEXT(Row(A1),”000-000″)

  • Enter the name of the first class in B1.
  • Enter the learning material of the first class in C1.
  • Copy cell A1 to A2.
  • Enter the name of the second class in B2.
  • Enter the learning material of the second class in C2.
  • Select A1:C2.
  • Go to Data | List and select Create List.

Data List Dialog Box

  • In Excel 2007, press CTRL + T and then click OK.

Notice, that when you type the name of the next class in B3 and press Tab, MS Excel will automatically provide the next number for you.

Autonumbered List

Tags: , , , , , , , , , , ,
Posted in Excel 2003, Excel 2007, Microsoft Office, Microsoft Office Excel | No Comments »

« Older Entries