Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tom B
 
Posts: n/a
Default Adding footnote to cell in Excel

Please help. How do you add a footnote number in an individual cell in a
worksheet. I work in an office that also uses Quatro-Pro and I have been
unable to duplicate the feature in Excel. Thanks for your help!
--
Eager to Learn in Colorado!
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tom B
 
Posts: n/a
Default Adding footnote to cell in Excel

While waiting for an answer I came up with a workaround. Here's the Rube
Goldberg solution. 1.) Add a column to the right of the cell and size it for
only one number. 2.) Type the number of the footnote you want. 3.) Make the
font of the number smaller than the font in the cell ( I used 6 when the cell
is 10. 4.) Align the cell with the number to be top justified and the click
to left justify the number in the cell. 5.) Make the number bold.

Presto! You now have your footnote reference. It would be much easier to
have that be a command in excel though!
--
Eager to Learn in Colorado!


"Tom B" wrote:

Please help. How do you add a footnote number in an individual cell in a
worksheet. I work in an office that also uses Quatro-Pro and I have been
unable to duplicate the feature in Excel. Thanks for your help!
--
Eager to Learn in Colorado!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
I want to use a formula in excel to highlight a cell 30 days prio MWad22368 Excel Worksheet Functions 1 February 13th 06 02:51 AM
excel cell lookup file on harddrive dj_siek Excel Discussion (Misc queries) 4 February 8th 06 12:09 AM
Pasting Word table cell with paragraph markers into single Excel c Steve Excel Discussion (Misc queries) 1 June 16th 05 11:26 PM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 04:55 PM


All times are GMT +1. The time now is 05:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"