Posts Tagged ‘column’

« 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 »

Move to the End of a Long Column in MS Excel Quickly

Monday, April 6th, 2009

This is one of those little tips that most folks aren’t aware of but are ever so grateful for the knowledge once they have learned it. Why??? Because it saves time and keystrokes of course!

To jump to the bottom of a very long column, simply select a cell in the column and double-click the top or bottom edge of the cell.

In a nanosecond you will be at the bottom of the data in that column, regardless of whether its 12,000 rows long!

To return to the top of your data, click the edge of the cell. Clicking the left or right edge of the cell works in the same manner for going across rows.

Now aren’t you glad I shared that with you? Just think what else you could learn if you were a Premium subscriber!

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

« Older Entries