Posts Tagged ‘hidden’

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 »

Creating Jury Instructions

Tuesday, January 6th, 2009

When you need jury instructions in your cases, you don’t have to create two separate documents – one for the judge, including citations at the bottom the page and another for the jury sans the citations.

This is a quick trick that will save you time and keystrokes, which of course is what I just love! Follow the steps below to learn how:

  1. Create your Jury Instructions for the judge, complete with citations.
  2. Now select the citations at the bottom of the page.
  3. Click on Format | Font.
  4. Under Effects, select Hidden, which will hide the citation text.
  5. When you are ready to print the judge’s Jury Instructions, click on File | Print or use the shortcut CTRL + P.
  6. From the Print menu, click the Options button.
  7. From the Print dialog box, select Hidden Text under Include with Document.
  8. Click OK two times to close the dialog box and print the document with cites.

Viola!  Trust me, I know how to save time in a law office!

Tags: , , , , , , ,
Posted in Word 2003 | 2 Comments »