advanced excel course - functiontoolbar

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel course - Function/toolbar

advanced excel course - Function/toolbar

resolvedResolved · Low Priority · Version Standard

Laura has attended:
Excel Introduction course

Function/toolbar

How do you bring back the toolbar if it disappears, or changes?

RE: function/toolbar

Hi Laura

Thank you for your question.

If you need to display a toolbar on the screen, right-click to the right of where you can see the toolbars currently at the top of your screen, and you should get a list of all the Excel toolbars you can choose from. If you select the toolbar you want from the list it will display on screen.

To reset a toolbar so it shows the buttons it had originally, go to Tools - Customise - Toolbars, select the toolbar you wish to reset so it is highlighted in blue, then click the Reset button.
Then click OK to exit the dialogue box.

Amanda


 

Excel tip:

Move data worksheet to worksheet

To move data from one worksheet to another, highlight the data.

Select and hold down the ALT key and position the mouse on the border of the selection until the mouse pointer displays four-headed arrows.

Drag the selection down to the destination worksheet tab.

When the arrow touches the tab, Excel switches to the desired worksheet. Now drag the selection to the correct position. Let go of the mouse and then the ALT key.

To copy data from one worksheet to another, select and hold down the CTRL+ALT keystroke combination and perform the steps above.

View all Excel hints and tips


Server loaded in 0.1 secs.