Articles about Computing
Spreadsheets
Excel spreadsheet design

Your spreadsheet columns can be formatted to your own taste. I like the trick of being able to format a cell for specific columns. You can create alternating columns, each with a distinctive style. In that way, you can distinguish one column from another. You might change the font or the cell shading for particular columns. However, when you add or remove cell columns in the spreadsheet, you will have to reformat each column individually.

You can make this change quickly with Format Painter. Yes, that’s the same Format Painter that you use in Word.

Click the top of a column to select the entire column. Double click on the Format Painter icon. It looks like a Paintbrush. Then click on any column which is supposed to have the same format for its cells as the selected item and every single one is going to have that formatting as you click on it so that you can easily change the formatting of the alternate cells I think that you mean columns. just by selecting one and then copying the formatting to the other cells. Please keep in mind that changing the formatting of the cell is irrelevant and has nothing to do with the contents of that cell. The contents do remain the same.

Where do you want to go now?

Find out about the Spreadsheet forum

More about spreadsheets

More about computerization

Find out about Jewish and Hebrew forums


Are you required to read this webpage for a course? Do NOT print out the article. It is copyrighted.
Your exercise for this article is as follows:

Click here for subject and title lists of articles by David Grossman

Copyright © David Grossman. World rights reserved. This article may not be printed, forwarded, reproduced, or copied in any way or in any medium without written permission from David Grossman.

/grossmancomputers/SS/ExcelDesign