Without doubtfulness, an Excel spreadsheet is one of the almost advanced tools for working with raw data—and one of the most feared. The application looks complicated, manner too advanced, and like something that would accept hours to figure out.
I wouldn’t be surprised if upon hearing that you had to first using MS Excel, your heart started to pound. Is there any fashion to brand Microsoft Excel less scary and intimidating? Yes.
By learning a few spreadsheet tricks, you lot tin bring Excel down to your level and start looking at the awarding in a different light. We rounded upwardly some of the simplest notwithstanding powerful MS Excel spreadsheet tips you tin first using on your data.
one. Utilize MS Excel Format Painter
To get-go yous off, become yourself familiar with formatting your spreadsheet cells. A visually organized spreadsheet is highly appreciated by others as it can assistance them follow your data and calculations easily. To quickly apply your formatting across hundreds of cells, utilize the Format Painter:
- Select the cell with the formatting you wish to replicate
- Become to the
Home
menu and click on the Format Painter. Excel will display a paintbrush side by side to the cursor. -
While that paintbrush is visible, click to apply all of the attributes from that cell to any other.
To format a range of cells, double-click the Format Painter during step 1. This will continue the formatting active indefinitely. Use the
ESC
button to deactivate it when you’re done.
two. Select Entire Spreadsheet Columns or Rows
Some other quick tip– utilise the
CTRL
and
SHIFT
buttons to select entire rows and columns.
- Click on the get-go cell of the data sequence you lot want to select.
- Concur downCTRL + SHIFT
- And then use the arrow keys to go all the data either in a higher place, below or side by side to the cell you’re in.
You tin can also use
CTRL + SHIFT + * to select your unabridged data set up.
iii. Import Information Into Excel Correctly
The do good of using is Excel is that you can combine different types of data from all kinds of sources. The trick is importing that information properly so you can create Excel drop downwardly lists or pivot tables from information technology.
Don’t copy-paste complex information sets. Instead, utilize the options from the
Go External Information
option under the
Information
tab. There are specific options for different sources. So use the appropriate option for your information:
4. Enter The Aforementioned Data Into Multiple Cells
At one betoken, you lot may discover yourself needing to enter the same data into a number of different cells. Your natural instinct would be to copy-paste over and over once more. Merely in that location’s a quicker style:
- Select all the cells where you need the aforementioned data filled in (utilise
CTRL + click
to select individual cells that are spread across the worksheet) - In the very last cell y’all select, type in your information
- Use
CTRL+ENTER.The information volition be filled in for each cell you selected.
5. Display Excel Spreadsheet Formulas
Jumping into a spreadsheet created by someone else? Don’t worry. You tin easily orient yourself and observe out which formulas were used. To practise this, apply the
Show Formulas
button. Or yous can apply
CTRL + ` on your keyboard. This will give y’all a view of all formulas used in the workbook.
6. Freeze Excel Rows And Columns
This is a personal favourite of mine when it comes to viewing lengthy spreadsheets. Once y’all roll by the first 20 rows, the first row with the column labels annoyingly disappear from view and yous brainstorm to lose track of how the data was organized.
To go along them visible, utilise the
Freeze Panes
feature under the
View
menu. You lot tin can opt to freeze the top row or, if you have a spreadsheet with numerous columns, you can opt to freeze the showtime column.
7. Enter
Data Patterns Instantly
Ane great feature in Excel is that it can automatically recognize data patterns. But what’south fifty-fifty better is that Excel will let y’all enter those data patterns to other cells.
- Simply enter your information in ii cells to plant your pattern.
- Highlight the cells. There will be a pocket-sized square in the lesser right hand corner of the last prison cell.
- Identify your cursor over this square until it becomes a blackness cantankerous.
- And so click and drag it with your mouse downwardly to populate the cells inside a column
eight. Hibernate 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’s. Isolate these cells from your work expanse (and prying optics) past hiding them:
- Select the beginning column or row in the range yous want to hibernate.
- Go to
Format
under the
Home
bill of fare. - Select
Hibernate & Unhide>Hide Rows
or
Hide Columns.
To unhide them, click on the kickoff row or cavalcade that occur just before and subsequently the hidden range. Repeat steps 2 and 3, but select
Unhide Rows
or
Unhide Columns.
9. Copy Formulas Or Information Between Worksheets
Another helpful tip to know is how to copy formulas and information to a separate worksheet. This is handy when you’re dealing with data that’s spread across different worksheets and requires repetitive calculations.
- With the worksheet containing the formula or data you wish to re-create opened,
CTRL + click
on the tab of the worksheet you lot want to copy information technology to. - Click on or navigate to the cell with the formula or data y’all demand (in the opened worksheet).
- Press
F2
to actuate the prison cell. - Press Enter. This will re-enter the formula or data, and it volition also enter it into the same respective cell in the other selected worksheet equally well.
These general tips won’t plough yous into an Excel guru overnight. But they tin can assistance you take that showtime pace towards condign one! Are you a well-seasoned Excel user? Which of your spreadsheet tricks would you add together?
22 Excel Tips For Becoming A Spreadsheet Pro
Source: https://www.investintech.com/resources/blog/archives/5430-excel-data-tips.html