标签:Excel
-
How to Lock Inserted Pictures to Excel Cells
When you use Excel to make a products list or personnel information table, inserting pictures can make it more informative. But if the inserted pictures can’t be locked to the cells, they’ll stay the same even when you make changes to the cells, which is quite frustrating. So, can we just lock the images to […]
-
How to Merge Multiple Tables from Different Excel Sheets
Sometimes you may have the need to create a comprehensive Excel document whose data comes from different files or even files edited by different people. It’s feasible to copy & paste the data manually if it isn’t too much. Otherwise you can try the Consolidate feature to let Excel do most of the work and […]
-
How to Reduce the File Size of Images in Microsoft Excel
A worksheet will become slow and heavy if there are too many images in the Excel file. We usually collaborate by sending files via email and a large one that weighs 50 MB can be hard to share with your colleagues. There are a few methods to reduce the file size of a worksheet, here […]
-
how to Quick Capitalize the First Letter or Each Word in Excel
When entering some specific information like company names or employee names into an Excel sheet, you may want to capitalize the first letter of each word in each cell. But instead of changing the text case one by one, can you do it in batch? 1. First of all, you can create a new column […]
-
How to Display Numbers in Excel as Cell Phone Numbers
In Excel spreadsheet, the long numbers are often displayed in segments, which is not only easy to view, but also more standardized. So how to segment long numbers in Excel cells and make them displayed as cell phone numbers? You can solve this kind of problem simply by change the setting in Format Cells. 1. […]
-
How to Print Excel Documents in Black and White
Some documents are not suitable for color printing, you may want to set the printer to black and white. So how can we achieve it? Here’s a simple guide. 1. First, click File in the upper left corner. 2. Then, click Print in the left-hand list box. 3. Next, click Page Setup at the right […]
-
How to Circle All the Invalid Data in Excel at Once
It’s not surprising that there’s some invalid data in an large Excel spreadsheet. If you want to screen out all of them at once, the best idea is to set Data Validation in Excel, and then choose to Circle Invalid Data. Here’re the detailed steps: 1.Select the cells. 2.Go to Data tab. 3.Click Data Validation […]
-
How to Sort Excel Cells by the Number of Characters
If most of the data in an Excel spreadsheet is text, and each cell has a different length of content, it may look untidy on the whole. For this situation, you can sort these cells by the number of characters. But as you know, there’s no such an existing sorting rule to use directly. Before […]
-
How to Recover an Unsaved File in Microsoft Word, Excel or PowerPoint
If you close a file in Microsoft Word, Excel or PowerPoint before saving it by accident, take these steps to recover the unsaved content in Office instead of restarting your hard work. 1. You might unexpectedly click Don’t Save button in Microsoft Office dialog box. 2. Click File at top left in the Ribbon. 3. […]