Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I make the comment show in a different part of the screee
I am seting up a spreadsheet that has comments in each cell. How can I move
the default location of the comments? DB |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I make the comment show in a different part of the screee
You can't change the default location. You have to manually do it or run
code -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "DB" wrote in message ... I am seting up a spreadsheet that has comments in each cell. How can I move the default location of the comments? DB |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I make the comment show in a different part of the screee
Right-click the cell with the comment you want to change, and then click
Show/Hide Comments on the shortcut menu or from View - Comments. Click the border of the comment box so that handles (sizing handle: One of the small circles or squares that appears at the corners and sides of a selected object. You drag these handles to change the size of the object.) appear. Do one of the following: Change the size Drag the handles on the sides and corners of the comment box. Move the comment Drag the border of the comment box. Note: If you hide and redisplay the comment, it returns to its default position. "DB" wrote: I am seting up a spreadsheet that has comments in each cell. How can I move the default location of the comments? DB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make a cell show the name of the sheet tab | Excel Worksheet Functions | |||
How do I make my spreadsheet so part of it has it's own scrollbar | Excel Discussion (Misc queries) | |||
Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel | |||
how do I make make my hyperlinks show the email address they are . | Excel Discussion (Misc queries) | |||
How can I make autofilter show the filtered number of rows | Excel Worksheet Functions |