Layout look (newbee question Thank!)

  • Thread starter Thread starter Adam Familia
  • Start date Start date
A

Adam Familia

Hello All,

Using MS Excel 2002, I have created an inventory sheets. Than deleted the
rest of the remaining sheets that I didn't have any needs for sheet 2, and
sheet 3. Now my question begin.

How can I remove/delete or customize all the remaining cells on my inventory
sheet that are outside from its boarders? So when I open up my inventory
sheet, only the actual sheet appear itself. No more constant cells still
remain from the left side, bottom, top etc. of the sheet. Its all about the
look when I open it.
I tried using filled white color so it doesn't show the grid line, but that
doesn't remove the remaining unnecessary cells and empty space.

I hope this wasn't too confusion for you to help me. What do you expect from
an exchange student. ;)

Thank you in advance!

Ps
Can you also please advise me how to add a background color after removing
the unnecessary cells? So it doesn't look so plain.


Adam Familia
 
Hi!

You can hide the columns and rows that you don't use:
Select all empty columns, from the Format menu select Column and then Hide
Select all empty rows, from the Format menu select Row and then Hide

Now all columns and rows you don't use is hidden


Best regards

Stefan Hägglund
Microsoft
 
First, I wouldn't hide the rows or columns. Most users of excel expect to see
them and aren't bothered by seeing them (just my opinion, though).

And instead of hiding the gridlines by changing the fill color, you could:
tools|options|view tab|uncheck gridlines

And to give a cell (or range of cells) a background color, you can select that
range and click on Format|Cells|Pattern tab|click on a color

(or use the icon on the Formatting toolbar that looks like a paint bucket being
poured. You'll see "Fill Color" if you let your cursor linger over the
icon--and you show tooltips!)

===
Just a note about the number of worksheets in each new workbook you use. I
don't like to have unused sheets in the workbook--I find it a waste of time to
have to check to see if it's used.

But you can change the default number of sheets via:
tools|options|General tab|sheets in new workbook
(I use 1)

I can add more sheets by rightclicking on a worksheet tab and selecting
Insert...
or by clicking on Insert|worksheet.
 
Stefan and Dave, Thank you for the tips!

Adam


Dave Peterson said:
First, I wouldn't hide the rows or columns. Most users of excel expect to see
them and aren't bothered by seeing them (just my opinion, though).

And instead of hiding the gridlines by changing the fill color, you could:
tools|options|view tab|uncheck gridlines

And to give a cell (or range of cells) a background color, you can select that
range and click on Format|Cells|Pattern tab|click on a color

(or use the icon on the Formatting toolbar that looks like a paint bucket being
poured. You'll see "Fill Color" if you let your cursor linger over the
icon--and you show tooltips!)

===
Just a note about the number of worksheets in each new workbook you use. I
don't like to have unused sheets in the workbook--I find it a waste of time to
have to check to see if it's used.

But you can change the default number of sheets via:
tools|options|General tab|sheets in new workbook
(I use 1)

I can add more sheets by rightclicking on a worksheet tab and selecting
Insert...
or by clicking on Insert|worksheet.
Click to expand...
 
Back
Top