Democratic Underground Latest Greatest Lobby Journals Search Options Help Login
Google

Office 03 spreadsheet help

Printer-friendly format Printer-friendly format
Printer-friendly format Email this thread to a friend
Printer-friendly format Bookmark this thread
Home » Discuss » DU Groups » Computers & Internet » Computer Help and Support Group Donate to DU
 
lazarus Donating Member (1000+ posts) Send PM | Profile | Ignore Sun Feb-14-10 08:55 PM
Original message
Office 03 spreadsheet help
So, I'm still using Office '03. I like it, mostly. But I have a couple of questions about comments in Excel

First, is there a way to change the default width? I always use 4" for the width, but it defaults to 1.5", making me change it each time.

Also, is there a way to change the default background colour in the comments for each page? I have 30 or so comments on each of 20 pages, and I dread having to go through and change the colour for each one. I'll be doing a different colour for each page, if I can do this.

Thank you!
Refresh | 0 Recommendations Printer Friendly | Permalink | Reply | Top
EvolveOrConvolve Donating Member (1000+ posts) Send PM | Profile | Ignore Sun Feb-14-10 11:02 PM
Response to Original message
1. I'm using Office 2007, but I may have an idea
You may be able to select all the comments using the CTRL key (it might be SHIFT, but usually it's the CTRL key). First, click the cell with the first comment. Second, hold down CTRL and click the cell with the second comment. Continue holding CTRL as you select all the cells with comments. Then, right click one of the cells with a comment and select Edit Comment.

You might want to try it with only 2 comments first to see if Excel allows you to edit multiple comments before you take the time to select them all.
Printer Friendly | Permalink | Reply | Top
 
lazarus Donating Member (1000+ posts) Send PM | Profile | Ignore Sun Feb-14-10 11:34 PM
Response to Reply #1
2. tried it
didn't work. Thanks for the tip, though.
Printer Friendly | Permalink | Reply | Top
 
DU AdBot (1000+ posts) Click to send private message to this author Click to view 
this author's profile Click to add 
this author to your buddy list Click to add 
this author to your Ignore list Thu May 02nd 2024, 05:06 AM
Response to Original message
Advertisements [?]
 Top

Home » Discuss » DU Groups » Computers & Internet » Computer Help and Support Group Donate to DU

Powered by DCForum+ Version 1.1 Copyright 1997-2002 DCScripts.com
Software has been extensively modified by the DU administrators


Important Notices: By participating on this discussion board, visitors agree to abide by the rules outlined on our Rules page. Messages posted on the Democratic Underground Discussion Forums are the opinions of the individuals who post them, and do not necessarily represent the opinions of Democratic Underground, LLC.

Home  |  Discussion Forums  |  Journals |  Store  |  Donate

About DU  |  Contact Us  |  Privacy Policy

Got a message for Democratic Underground? Click here to send us a message.

© 2001 - 2011 Democratic Underground, LLC