How to Find the Last Row With Data in Excel
If you add rows to a list every week, you’ll often need to know where the data ends. Sometimes you just want to jump there. Other times you need that …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
How to Convert Date to Fiscal Year in Excel
A fiscal year is the 12-month period a company or government uses for its accounts, and it often doesn’t start in January. If your fiscal year runs from July to …
How to Filter Horizontally in Excel (Filter Across Columns)
Excel’s Filter button only works one way. It hides rows, so it can’t help when your data runs sideways, with each record in its own column. You see this layout …
How to Make a Slicer Drop-Down List in Excel
A slicer in Excel lets you filter a PivotTable with one click. But with a lot of items, it becomes a tall stack of buttons that crowds your report. A …
How to Add a Search Box to a Slicer in Excel
A slicer is great when it has five buttons. When it has 36, you end up scrolling up and down the list, hunting for the one item you want. Excel …
How to Limit a Slicer to One Selection in Excel
Slicers let anyone filter a report with one click. But some reports only make sense for one item at a time, like a sales summary for a single store or …
How to Change Slicer Font Size, Color and Style in Excel
Slicers are the easiest way to filter a report. But every new one looks the same, with small text on pale blue buttons that rarely match your workbook. You can …
How to Protect a Sheet but Allow Slicers in Excel (and Lock Their Position)
Slicers make a report easy to filter, and sheet protection stops people from typing over your numbers. Put the two together, though, and the slicer buttons usually stop responding. That’s …
How to Get the Start and End Date of a Week in Excel
If you track anything by week, you’ll often need the week start date for each date in your data. That’s the date a Wednesday entry and a Friday entry from …
How to Make a Pie Chart in Excel (With Percentages)
A pie chart in Excel shows how a total splits into parts, like how much of your weekly sales each product brings in. Making the basic chart takes a couple …
How to Custom Sort Slicer Items in Excel (Months and Custom Order)
A slicer in Excel lists its buttons in alphabetical order by default. That’s fine for product names, but not for things that have a natural order. Shifts should run Morning, …
Convert Inches to Feet and Inches in Excel (Without the 5′ 12″ Bug)
If you have lengths stored in inches, like 71.8 for a dining table, you probably want to show them the way people read them: 5′ 11.8″. Excel has no built-in …