76. How to use Fill In the Blanks in Spreadsheets the Easy Way
77. How to View All the Text in Your Columns
78. How to Fill a Selected Range with the Same Data
76. Fill In the Blanks in Spreadsheets the Easy Way
1. Select all the rows in your Microsoft Office Excel spreadsheet data set.
2. On the Home tab, in the Editing section, click Find & Select, click Go To, click Special, click Blanks, and then click OK.
3. Click the equal sign (=) on the toolbar, select the cell above, and then hold down the CTRL key while you press ENTER. Blanks in the spreadsheet will be filled automatically.
4. Copy all the data, click Paste Special, and then click Values. This will overwrite the formulas and enable you to sort the data by filling in each empty cell with the same information as the one above. This tip will work on any size of data set.
77. View All the Text in Your Columns
In Microsoft Office Excel, you can resize multiple columns to different widths so that you can see all the text in your spreadsheet.
1. Select the columns where your text appears by clicking the column headings. Select multiple columns if necessary.
2. To resize the columns to fit, double-click in the column heading, exactly on top of the border that divides any of the two columns you selected.
All of your selected columns are resized based on the longest text string in each column. In this way, a large and confusing spreadsheet with lots of text that you can't see is converted into a legible spreadsheet with all text showing.
78. Fill a Selected Range with the Same Data
Need to enter the same data in a range of cells? Here’s how:
1. Select a range of cells.
2. Type in some data.
3. Use the fill function in Microsoft Office Excel—press CTRL+ENTER, and the range selected will be filled with the same data.
2. On the Home tab, in the Editing section, click Find & Select, click Go To, click Special, click Blanks, and then click OK.
3. Click the equal sign (=) on the toolbar, select the cell above, and then hold down the CTRL key while you press ENTER. Blanks in the spreadsheet will be filled automatically.
4. Copy all the data, click Paste Special, and then click Values. This will overwrite the formulas and enable you to sort the data by filling in each empty cell with the same information as the one above. This tip will work on any size of data set.
77. View All the Text in Your Columns
In Microsoft Office Excel, you can resize multiple columns to different widths so that you can see all the text in your spreadsheet.
1. Select the columns where your text appears by clicking the column headings. Select multiple columns if necessary.
2. To resize the columns to fit, double-click in the column heading, exactly on top of the border that divides any of the two columns you selected.
All of your selected columns are resized based on the longest text string in each column. In this way, a large and confusing spreadsheet with lots of text that you can't see is converted into a legible spreadsheet with all text showing.
78. Fill a Selected Range with the Same Data
Need to enter the same data in a range of cells? Here’s how:
1. Select a range of cells.
2. Type in some data.
3. Use the fill function in Microsoft Office Excel—press CTRL+ENTER, and the range selected will be filled with the same data.
Posts
0 Comments:
Post a Comment