Look Who it Was Random video

Excel - Add Paste Formulas Icon to Excel Toolbar - Episode 441

264 views · Published 9 June 2009 · 2:33 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Add Paste Formulas Icon to Excel Toolbar.

Welcome to another episode of the MrExcel netcast, where we answer all your burning Excel questions. I'm your host, Bill Jelen, and today we have a question from Eric in Shanghai. Eric wants to know if there's a way to add an icon for paste formulas to his customized toolbar. Well, Eric, you're in luck because in this episode, we'll show you exactly how to do that.

First, let's go over the basics of customizing your toolbar. This only works for Excel 97 through Excel 2003. Simply go to the Tools menu and select Customize. From there, you can drag and drop any icon from the dialog box onto your toolbar. In the Edit category, you'll find options for Paste Formatting, which you can add next to the Paste button and Paste Values. However, as you scroll through the options, you'll notice that there's no option for paste formulas.

But don't worry, there's a workaround for this. You can actually take anything from the menu bar and copy it to your toolbar. At first, I didn't think this would work because the Edit menu only has an option for Paste Special, not Paste Formulas. However, if you look at the standard toolbar, you'll see a drop-down menu next to the Paste icon, which includes the option for Paste Formulas. You can simply drag and drop the word "Formulas" onto your toolbar while holding down the control key.

Now, you may notice that the icon for Paste Formulas is just the word itself, which can be a bit irritating. But don't worry, you can change it to an image by right-clicking on it and selecting "Change Button Image." You can choose from the available images or even create your own using the Icon Editor. And there you have it, Eric. Your customized toolbar now includes an icon for Paste Formulas. Thanks for sending in your question all the way from Shanghai, China. If you have a question of your own, don't hesitate to reach out to us and we'll feature it on a future podcast. Thanks for tuning in and we'll see you next time!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Eric from Shanghai writes in with a question about adding a Paste Formulas icon to the standard toolbar in Excel. While Excel only offers custom buttons for Paste Values and Paste Formats, Episode 441 will help you discover how to get a Paste Formulas icon on your toolbar.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Table of Contents:
(00:00) Introduction 
(00:21) Customizing the Toolbar 
(00:46) Adding Paste Formulas 
(01:19) Changing Button Image 
(02:00) Creating a New Icon 
(02:12) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Adding icons to Excel toolbar
Adding paste formatting and paste values icons to Excel toolbar
Adding paste formulas icon to Excel toolbar workaround
Changing button image in Excel toolbar
Changing text to default style in Excel toolbar
Creating new icon in Excel toolbar
Customizing toolbar in Excel 97-2003
Drag and drop icons onto Excel toolbar
How to add paste formulas icon to Excel toolbar
How to customize Excel toolbar
MrExcel tutorial on customizing Excel toolbar
YouTube tutorial on customizing toolbar in Excel

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152451/

More from this channel