How Do I show only certain cells in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a Sudoku puzzle for the elementary school I work for. I am
wanting only the cells that I am using to appear on the screen. Basically, I
don't want the kids to see all the "extra" columns and rows that are not
being used. I have seen this done on some fun emails that I have received in
the past, but not sure how to do it myself. I don't want to just darken the
extra cells so that they can't be seen because that would take too long (I
have 100 worksheets). Is there any way to limit the viewing to just certain
cells?
 
You can select those columns (or rows), then Format|column (or Row)|Hide

You may want to unlock the cells that the kids can write in (select the
cells|format|cells|protection tab|uncheck locked)

Then protect the worksheet
tools|protection|protect sheet.

Depending on how precocious these kids are, it may work--worksheet protection
isn't too difficult to break.
 
Hi: Use Conditional Formatting to either format Fonts to white, or
Patterns to Black in one cell you want to hide. If you're in cell B-1
put the Conditional Formatting formula =isblank(T-1). Then use the
Format brush to "swipe" all the cells you want hidden. Then set
Formatting to Locked and Hidden except for the cells allowing input,
and Protect the spreadsheet with a password.

When you want to see your hidden cells un-protect the worksheet and
type any number or text in cell T-1. To return to user conditions,
CLear Contents of T-1 and Protect the worksheet with your formula.
ed.
 
I know how to protect the worksheet and all that....and hiding would be ok if
I didn't have to hide a million endless pages

I can't hide enough columns or rows so that all the kids see are the cells
containing the puzzle.
 
If your puzzle is in A1:Z99 (say).

You can select rows 100:65536 by:
edit|goto|type in
100:65536
in the reference box
and hit enter
format|row|hide

Then
edit|goto|type in
AA:IV
in the reference box
and hit enter
format|column|hide
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protect Only Certain Cells 2
How do I lock certain cells in excel 2007? 1
Filter certain cells 1
Faint cell highlighting in Excel 2007 4
restrict view of certain cells in excel 2
HOW DO I LOCK CERTAIN CELLS 2
Protect (Lock) Cell Formatting ONLY 13
Can you only merge up to a certain number of cells 2

Back
Top