How I Show Only Cells of Excel

1. To get rid of the toolbars, go View, Toolbars, and un-check all the boxes.

2. To get rid of sheet formatting, go Tools, Options, then on the View tab. On the View tab page, you can un-check row and column headings, grid lines, etc.

These 2 items leave you with just a Window. You don't really need to, but I suppose you could write a macro or VBA code to accomplish this.

If I have located cells with values that I don't wish to be seen where I can't hide the row/column, I sometimes switch the text color of those cells to white.

I usually try to make calculation and constant value cells in the same row. That way the row can be unhidden for easier editing, hidden for general use.

You can write your formula cells on another page and have the first page refer to them. This way your front page only shows what you want it to.

Drew K

The responses to your post are each very good, but there is yet at least one other way that might also be valuable, as well.

First, consider resizing all the columns you want to hide by changing their widths to zero.

Then, consider similarly resizing all the rows you want to hide by also changing their heights to zero.

All that's still showing is the cells that you want to show.

Then, try experimenting with each alternative, and/or combinations of alternatives, to find what suits your purposes best.

In any case, come back and tell us how it all works out.

And, I should also clarify that all the original contents of each cell are all still there, and still accessible, by reversing the sequence and changing the ''zeroed'' columns and rows back their original widths of 8.43 and original heights of 12.75 (or, say, 9 by 13, or whatever non-zero values you happen to prefer). Try it and see for yourself.

One of the tricks I teach people is to have cells with the text in the same color as the cell's fill color. That way, the cell looks empty. To keep the contents of that cell safe, I use the protect feature so that you can't type into the cell.

regards,

Vulcan

The forms function of Excel is designed for such a purpose.

Use the wizard included with Excel (dependent on version) to allow the user to enter data into selected fields without actually using the spreadsheet. Link the form entry and results to your spreadsheet...like this ^_(click).

Put daisies and/or puppies in the background to make it user friendly.