ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I add sum function to the toolbar permanently (https://www.excelbanter.com/excel-discussion-misc-queries/27130-how-do-i-add-sum-function-toolbar-permanently.html)

speedy2

how do I add sum function to the toolbar permanently
 
The standard toolbar does not display the sum function on the toolbar. If I
go to View-Toolbar-Customize, I see it at the top. If I double click on the
toolbar "Standard Toolbar" appears with all the functions but too long for
the screen. I can resize it but it covers part of my Excel document. In later
versions of Excel, I just drag and drop and it stays but this one does not.
This is a function I use quite a bit and would like for it to be assessible
all the time.

PC

Go into Tools/Customize and on the Options tab uncheck Standard and
Formatting Toolbars share one row.

HTH

PC


"speedy2" wrote in message
...
The standard toolbar does not display the sum function on the toolbar. If

I
go to View-Toolbar-Customize, I see it at the top. If I double click on

the
toolbar "Standard Toolbar" appears with all the functions but too long for
the screen. I can resize it but it covers part of my Excel document. In

later
versions of Excel, I just drag and drop and it stays but this one does

not.
This is a function I use quite a bit and would like for it to be

assessible
all the time.





All times are GMT +1. The time now is 02:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com