6 Tips To Make the Best Spreadsheet on Excel or Google Sheets
-
Loading... - Manu Anttila
- 19 Apr 2023
- 67 Views
- 0 Like
- 0 Comment
Making a spreadsheet? These hacks will help.
There are dozens of reasons to make a spreadsheet like business presentations, school presentations, budgeting, habit-tracking, book-tracking and managing the kids' chores. But how do you make your spreadsheet pop for that special meeting? How do you make Google Sheets or Excel work for you, and not the other way around?
These programs are packed full of useful features, as well as shortcuts to work smarter, not harder.
Here are six tips to turn you into a spreadsheet pro whether you're using Microsoft Excel or Google Sheets.
Alphabetize your data
You can customize your spreadsheet data a number of ways, including alphabetical -- or reverse alphabetical -- order.
Here's how for Google Sheets:
1. Highlight a column or click the capital letter at the top of the column.
2. Click the down arrow to open the dropdown menu.
3. Choose Sort sheet A-Z or Sort sheet Z-A. Note that sorting A-Z will also arrange numbers from lowest to highest, and sorting Z-A will arrange them from highest to lowest.
Here's how for Excel:
1. Highlight a column
2. Click the Data tab
3. Click A-Z for alphabetical order or Z-A for reverse alphabetical order.
Add checkboxes
Who doesn't love a to-do list? If you're using a spreadsheet for task completion or habit-tracking, checkboxes can be helpful. Read More…
