Join Two or More AutoShapes to Create a Group so You Can Move Them Together - Excel Tips & Tricks at Bright Hub
In Excel, you can group AutoShapes to make it easier to move them to a new location.
Continue ReadingShowing items from business
Learn How to Color Cells Green for Sales that Exceed $1000 - Use Microsoft Excel More Efficiently
Problem: Your company offers a bonus pool on any day where the total sales exceed $1,000. You have invoice data by date, as shown in Fig. 1303. You …
Continue ReadingLearn How to Make Any Logo Into an AutoShape in Microsoft Excel
Turn your business logo into an Excel AutoShape with these easy steps.
Continue ReadingLearn How to Rotate Your Autoshape in Microsoft Excel
You can customize Excel AutoShapes in many ways – rotating them is one option.
Continue ReadingMicrosoft Excel Help: Delete Pictures in Pasted Data
Problem: You copy data from your bank’s Web page into Excel. On the Web page, the bank has little “check” icons that let you view a physical copy of …
Continue ReadingMicrosoft Excel Tips - Alter & Adjust Key Inflection Point to Make Autoshapes Narrower or Wider
The AutoShapes found in Microsoft Excel are more customizable than most people realize. Read on to learn how you can change the shape.
Continue ReadingControl Page Numbering in a Multisheet Excel Workbook So it Doesn't Always Print as Page 1 of 1
Page numbers not coming out the way you like when you print a workbook with multiple sheets? Try this solution.
Continue ReadingExcel Tips - How to Add a Page Break at Every Change in Customer
Problem: Your data is sorted by customer in column A, as shown in Fig. 1251. You want to put each customer on a different page.
Continue ReadingExcel Tips: Use White Font to Hide Data
Want to hide some of the data on your Excel spreadsheet to make it more visually appealing? Try this easy trick.
Continue ReadingFind Out How to Change the Width of All Columns in an Excel Worksheet With Just One Command
Have a large spreadsheet with hidden columns and want to change the width of all columns without unhiding any of them? Try this trick.
Continue ReadingFind Out How to Temporarily See a Hidden Column in Excel Without 'Un-Hiding' It
Problem: You have data hidden in column E, as shown in Fig. 1231. You want to quickly view data in the hidden column without actually unhiding it.
Continue ReadingHow to Add a Printable Picture to the Background of Your Excel Worksheet
Problem: You want to have a background image that can be printed. The Format – Worksheet – Background image will not print.
Continue Reading