Set a background image in Microsoft Excel with a macro button

in microsoftexcel •  6 years ago 

Most people see Microsoft Excel as a dull and monotonic platform, however, there are many ways to perform work in a much more pleasing and creative environment by applying few techniques to create attractive spreadsheets.
I'll attempt to share one such technique in this article which helps me in my workflow.
In this guide, you will learn how to:

  • Add a background image to your Excel worksheets
  • Automate the process of formatting your Excel worksheet
    1.png

Add a background image to your Excel worksheets

  1. The first thing you will have to do is download an image and place it in a dedicated folder on your local PC
  2. Let's set up a macro to automate the process. Go to Developer tab > Record a macro OR use the shortcut key Alt-L-R
    2.png
  3. At the macro window, you can leave every setting on default and press OK
    3.png
  4. At this stage, every step you make, the macro will record your action. Let's place the image as your background, use the shortcut keys Alt-P-G and browse for the image on your PC
    4.png
  5. At the next step, we will eliminate the gridlines to make our experience more smooth. Use the shortcut keys Alt-W-V-G to disable the gridlines.
    5.png
  6. If you chose a dark background image, you will have to set the fonts to white color. To do this, first, highlight the entire spreadsheet with Ctrl+A key. (In case your background image is bright, you can skip this step as the default black fonts are going to work well.)
    6.png
  7. Next use the shortcut keys Alt-H-F-C and navigate with your directional keys to the white color.
    6.5.png
  8. As the last step, you can stop the macro recording by using the shortcut keys Alt-L-R
    7.png

Automate the process of formatting your Excel worksheet:

In order to apply our automation to a one-click process, we will put the newly created macro to the Developer tab:

  1. Select File > More Commands > Customize Ribbon.
    8.png
  2. Check the "Developer" box inside the right panel, then click the plus + to expand and close the group under that tab.
  3. Select the Newly created group button (bottom center of the right panel), and press the "New Group" button at the bottom of the list.
  4. Next, press the "Rename" button, and enter the name for your new group and select a symbol from the listed icons; click OK when finished.
  5. Select Macros group from the left panel and all the macros you have available on your system will resemble.
  6. Pick the macro from the list you want to attach to the Ribbon and click the "Add" button to add it to your new custom group. Press OK after you finished.
    9.png
  7. Go to the Developer tab where the Macros group is located (right end of the menu) with your chosen macro functions. This way, you can execute your task quickly with the custom made macro button.
    10.png
Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

✅ Enjoy the vote! For more amazing content, please follow @themadcurator for a chance to receive more free votes!

@exgap purchased a 5.99% vote from @promobot on this post.

*If you disagree with the reward or content of this post you can purchase a reversal of this vote by using our curation interface http://promovotes.com

You got a 0.38% upvote from @minnowvotes courtesy of @exgap!