Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 3 123 LastLast
Results 1 to 10 of 21

Thread: what do YOU have on your toolbar

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi.

    A light hearted posting now.....

    What custom features on your toolbar etc. have you got on your excel that you could not live without? What little macros do you have that you need all the time to make your life easier?

    RET79

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    363
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    My custom created buttons are:
    Paste Special Formulas
    Paste Special Multiply
    Next Window
    Previous Window
    Edit Goto Special Errors
    Change Center Accros Selection to do so without merging cells
    Accounting Underline
    It's never too late to learn something new.

    Ricky

  3. #3
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm sooo jealous. I need to keep a *regulation* install. Otherwise, I can't help my users.

    And then if I changed it at home, it would get me all messed up.


    ~Anne Troy

  4. #4
    New Member
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    42
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ricky how do you make or where do you get the 'Center across selection' button? That is so valuable. I'd love to NOT have to go through the Format Cells thing.

  5. #5

    Join Date
    May 2002
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-06 00:04, Phylis Sophical wrote:
    Ricky how do you make or where do you get the 'Center across selection' button? That is so valuable. I'd love to NOT have to go through the Format Cells thing.

    Create your own button and assign a macro.

    You can record a macro (and put it in your Pesonal.xls), a tidied-up version of which :-

    Sub Centre_Across_Selection()
    Selection.HorizontalAlignment = xlCenterAcrossSelection
    End Sub

    You can create your own buttons and assigned macros for whatever you want.
    For example, among the many I use :-

    - Disable/enable event procedures
    - Turn off move after entry
    - Toggle formula cells between showing the result and showing the formula (good for copying formulas and pasting elsewhere)
    - Convert formulas to values
    - Copy non-contiguous selections
    - Identify cells containing formulas
    - Reset last cell
    - Unhide next column (or next row)
    - Wrap text
    - Add a leading bullet
    - Convert to lower/upper/proper case
    - Capitalise first letter only
    - Count of pages that will print
    etc.
    etc.


  6. #6

    Join Date
    May 2002
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-05 19:29, Dreamboat wrote:
    I'm sooo jealous. I need to keep a *regulation* install. Otherwise, I can't help my users.

    And then if I changed it at home, it would get me all messed up.


    Why not have a separate customised toolbar (at least at home) for all your custom buttons?

  7. #7
    Board Regular
    Join Date
    Apr 2002
    Location
    Minnesota
    Posts
    821
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The special "buttons" I could not live without are the macros that I use to navigate very large spreadsheets:

    Here (Names a cell Here)
    Go to Here
    There (Names a cell There)
    Go to There
    Go to dialog box

    There are also special toolbars that open automatically when I use only for certain workbooks.

  8. #8
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have the following:

    Paste Special
    GoTo
    Autofit Columns
    Cascade

    and that's all I can remember for now...

    RET79

  9. #9
    Board Regular Barry Katcher's Avatar
    Join Date
    Feb 2002
    Location
    Dog Beach, Florida. Yeaahh!
    Posts
    4,053
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    To Phylis Sphical:

    No need for code. To customize your toolbar with the "Merge Cells" button, do the following:

    Click on Tools-Customize-Commands
    In the "Categories" box, highlight "Format".
    Scroll down to "Merge Cells".
    Click and drag the icon up to your "Edit" toolbar (or any other toolbar).

    You can edit any toolbar with any of the icons in any of the categories this way. I now have 17 layers of toolbars. Of course, my spreadsheet is down to 4 rows, but what the hey.
    Barry-

    Photo Restoration/Enhancement

    http://www.smiledogproductions.com
    click below for detour


  10. #10

    Join Date
    May 2002
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-06 07:26, Barry Katcher wrote:
    To Phylis Sphical:

    No need for code. To customize your toolbar with the "Merge Cells" button, do the following:

    Click on Tools-Customize-Commands
    In the "Categories" box, highlight "Format".
    Scroll down to "Merge Cells".
    Click and drag the icon up to your "Edit" toolbar (or any other toolbar).

    You can edit any toolbar with any of the icons in any of the categories this way. I now have 17 layers of toolbars. Of course, my spreadsheet is down to 4 rows, but what the hey.

    Phylis was not looking for a merge cells button.
    She was looking for a button to center across selected cells (without merging).
    I can't find such a button in any of the toolbar available commands - and so suggested a custom button with appropriate macro.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •