Excel How to Quickly Format the Same Sheet Over and Over Again

Without doubt, an Excel spreadsheet is i of the near advanced tools for working with raw data—and one of the most feared.  The awarding looks complicated, style too advanced, and like something that would have hours to figure out.

I wouldn't be surprised if upon hearing that you had to outset using MS Excel, your centre started to pound. Is there any way to make Microsoft Excel less scary and intimidating? Yes.

Past learning a few spreadsheet tricks, y'all can bring Excel downward to your level and showtime looking at the application in a different light.  We rounded up some of the simplest withal powerful MS Excel spreadsheet tips you tin start using on your data.

1. Use MS Excel Format Painter

To showtime you off, go yourself familiar with formatting your spreadsheet cells. A visually organized spreadsheet is highly appreciated by others as information technology can help them follow your data and calculations easily. To quickly apply your formatting across hundreds of cells, utilize the Format Painter:

1. Select the cell with the formatting yous wish to replicate
2. Get to the Domicile carte du jour and click on the Format Painter. Excel will display a paintbrush next to the cursor.
3. While that paintbrush is visible, click to apply all of the attributes from that jail cell to any other.

To format a range of cells, double-click the Format Painter during pace 1. This will keep the formatting agile indefinitely. Use the ESC push button to deactivate it when yous're washed.

2. Select Entire Spreadsheet Columns or Rows

Another quick tip– use the CTRL and SHIFT buttons to select entire rows and columns.

1. Click on the first cell of the data sequence you want to select.
2. Hold downwardCTRL + SHIFT
3. And so apply the arrow keys to get all the information either above, below or side by side to the prison cell you're in.

You can too use CTRL + SHIFT + *   to select your unabridged information set up.

iii. Import Data Into Excel Correctly

The benefit of using is Excel is that you lot can combine different types of data from all kinds of sources.  The trick is importing that information properly so yous tin create Excel driblet down lists or pin tables from it.

Don't copy-paste complex information sets. Instead, use the options from the Get External Data option nether the Data tab. At that place are specific options for different sources. Then use the advisable option for your information:

iv. Enter The Same Data Into Multiple Cells

At ane indicate, you may find yourself needing to enter the same information into a number of dissimilar cells. Your natural instinct would be to copy-paste over and over over again. But there'south a quicker way:

1. Select all the cells where you lot demand the same data filled in (use CTRL + click to select private cells that are spread across the worksheet)
2. In the very last cell you select, blazon in your data
3. Utilise CTRL+ENTER.The data will be filled in for each cell y'all selected.

5. Display Excel Spreadsheet Formulas

Jumping into a spreadsheet created by someone else? Don't worry. You tin can easily orient yourself and observe out which formulas were used. To do this, employ the Show Formulas push button. Or you can employ CTRL + `  on your keyboard. This will requite you a view of all formulas used in the workbook.

vi. Freeze Excel Rows And Columns

This is a personal favourite of mine when information technology comes to viewing lengthy spreadsheets. Once you lot scroll by the get-go 20 rows, the get-go row with the column labels annoyingly disappear from view and you begin to lose track of how the data was organized.

To continue them visible, use the Freeze Panes characteristic under the View menu. You lot can opt to freeze the top row or, if you have a spreadsheet with numerous columns, you can opt to freeze the first column.

7. Enter Data Patterns Instantly

One keen feature in Excel is that it can automatically recognize information patterns. But what's fifty-fifty better is that Excel will let you enter those information patterns to other cells.

1. Simply enter your information in two cells to establish your blueprint.
2. Highlight the cells. At that place volition be a small-scale square in the bottom right mitt corner of the last cell.
3. Place your cursor over this square until information technology becomes a blackness cross.
4. Then click and drag it with your mouse downwards to populate the cells within a column

8. Hide Spreadsheet Rows and Columns

In some cases, you may have information in rows or columns that are for your eyes only and no one else'due south. Isolate these cells from your work surface area (and prying eyes) by hiding them:

1. Select the offset column or row in the range y'all want to hide.
2. Get to Format under the Dwelling house menu.
3. Select Hide & Unhide>Hide Rows or Hide Columns.

To unhide them, click on the first row or column that occur just before and after the subconscious range. Repeat steps 2 and 3, but select Unhide Rows or Unhide Columns.

nine.  Copy Formulas Or Data Betwixt Worksheets

Another helpful tip to know is how to copy formulas and information to a separate worksheet. This is handy when you lot're dealing with information that'southward spread across different worksheets and requires repetitive calculations.

1. With the worksheet containing the formula or information you wish to copy opened, CTRL + click on the tab of the worksheet you lot want to re-create it to.
2. Click on or navigate to the cell with the formula or data y'all need (in the opened worksheet).
3. Press F2 to actuate the prison cell.
4. Press Enter.  This will re-enter the formula or data, and it volition likewise enter information technology into the same corresponding cell in the other selected worksheet every bit well.

These general tips won't turn you into an Excel guru overnight. But they can assist you take that first step towards becoming one! Are you a well-seasoned Excel user? Which of your spreadsheet tricks would you add together?

wennertroarat.blogspot.com

Source: https://www.investintech.com/resources/blog/archives/5430-excel-data-tips.html

Share this post