Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default how do you hide SUM(number1,[number2],...

This box is in my way when using @sum, but I am unable to find how to hide it.

how do you hide SUM(number1,[number2],...
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,090
Default how do you hide SUM(number1,[number2],...

Karen
Tell us more. What are you doing? In detail. What is happening? In
detail. For instance, what box? HTH Otto
"Karen@Industrialrevolution"
. com wrote in message
...
This box is in my way when using @sum, but I am unable to find how to hide
it.

how do you hide SUM(number1,[number2],...



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default how do you hide SUM(number1,[number2],...

Otto,

When I am in a cell and use the @sum button to total a column of numbers, a
yellow box appears that has SUM(number1,[number2],... This box is right next
to the cell I am putting the total into. This box is in my way when I am
highlighting the area to sum.

"Otto Moehrbach" wrote:

Karen
Tell us more. What are you doing? In detail. What is happening? In
detail. For instance, what box? HTH Otto
"Karen@Industrialrevolution"
. com wrote in message
...
This box is in my way when using @sum, but I am unable to find how to hide
it.

how do you hide SUM(number1,[number2],...




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default how do you hide SUM(number1,[number2],...


Karen@Industrialrevolution wrote:
Otto,

When I am in a cell and use the @sum button to total a column of numbers, a
yellow box appears that has SUM(number1,[number2],... This box is right next
to the cell I am putting the total into. This box is in my way when I am
highlighting the area to sum.


I know what you're talking about, but I don't understand how it would
be in the way. Just out of curiosity, what cells are you trying to
sum, and into which cell are you trying to put the sum?

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,090
Default how do you hide SUM(number1,[number2],...

Karen
I don't see what you mean. I see the box but it appears below the
active cell. Post back with specifics about the cells involved. Also,
describe what cells are visible on the screen as you do this. Otto
"Karen@Industrialrevolution"
om wrote in message
...
Otto,

When I am in a cell and use the @sum button to total a column of numbers,
a
yellow box appears that has SUM(number1,[number2],... This box is right
next
to the cell I am putting the total into. This box is in my way when I am
highlighting the area to sum.

"Otto Moehrbach" wrote:

Karen
Tell us more. What are you doing? In detail. What is happening?
In
detail. For instance, what box? HTH Otto
"Karen@Industrialrevolution"
. com wrote in message
...
This box is in my way when using @sum, but I am unable to find how to
hide
it.

how do you hide SUM(number1,[number2],...








  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,090
Default how do you hide SUM(number1,[number2],...

Karen
You can also do this another way. Perhaps that would work for you. In
the cell in which you want the sum, type "=sum(" without the quotes). Then
highlight the cells you want to sum and hit enter. That way, no box appears
anywhere. Otto
"Karen@Industrialrevolution"
om wrote in message
...
Otto,

When I am in a cell and use the @sum button to total a column of numbers,
a
yellow box appears that has SUM(number1,[number2],... This box is right
next
to the cell I am putting the total into. This box is in my way when I am
highlighting the area to sum.

"Otto Moehrbach" wrote:

Karen
Tell us more. What are you doing? In detail. What is happening?
In
detail. For instance, what box? HTH Otto
"Karen@Industrialrevolution"
. com wrote in message
...
This box is in my way when using @sum, but I am unable to find how to
hide
it.

how do you hide SUM(number1,[number2],...






  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,572
Default how do you hide SUM(number1,[number2],...

To eliminate that tool tip, go to:
<Tools <Options <General tab,
And *UNCHECK*
"Function Tooltips".

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Karen@Industrialrevolution"
om wrote in message
...
Otto,

When I am in a cell and use the @sum button to total a column of numbers, a
yellow box appears that has SUM(number1,[number2],... This box is right next
to the cell I am putting the total into. This box is in my way when I am
highlighting the area to sum.

"Otto Moehrbach" wrote:

Karen
Tell us more. What are you doing? In detail. What is happening? In
detail. For instance, what box? HTH Otto
"Karen@Industrialrevolution"
. com wrote in message
...
This box is in my way when using @sum, but I am unable to find how to

hide
it.

how do you hide SUM(number1,[number2],...






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
How can I hide a range of columns without hiding charts there? dbsavoy Charts and Charting in Excel 2 August 31st 06 04:30 PM
How do you permanently hide and password protect a column? Vegetable Dave Excel Discussion (Misc queries) 5 June 6th 06 06:34 PM
Can anyone tell me how to hide rows that have 0 values and text. Aussie Charts and Charting in Excel 2 April 13th 06 10:57 AM
Macro to hide blank cells in a range Dave Excel Discussion (Misc queries) 1 February 1st 06 11:55 PM
How Do I Hide A Row (if a condition is true) using a Macro ? Anthony Fantone Excel Worksheet Functions 1 June 16th 05 04:54 PM


All times are GMT +1. The time now is 01:21 AM.

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

About Us

"It's about Microsoft Excel"