• Blog
  • Excel Downloads
    • Audit Tickmark Toolbar
  • Courses
  • Contact
  • Checkout

Excel Zoom

...because it's more than just a calculator


Remove All Rows Containing Certain Data

July 20, 2015 by Mark 7 Comments

remove all rows containing certain data

Recently I had some data from a website that was poorly formatted, but I needed to get it into a spreadsheet to work with. When I copied the data into the spreadsheet, I needed to remove all of the rows that contained certain irrelevant data, such as repeated header fields. Other use cases might require you to delete any rows containing someone's name, a location, or some … [Read more...]

Type Same Data In Multiple Cells

August 29, 2015 by Mark Leave a Comment

Same Data Multiple Cells

Have you ever had the need to type the same data in multiple cells in your Excel spreadsheet? If so, you know it can be quite the time consuming process if you have to manually type the data in a lot of cells. Even copying and pasting can be time consuming. Luckily there is an easy way to type same data in multiple cells. How to type same data in multiple cells Select all … [Read more...]

10 Excel Tips For Increased Productivity

July 4, 2014 by Mark 4 Comments

Excel Tip Tab Color

Microsoft Excel has tons of uses available to its users. But not everyone knows all the features that Excel has to offer. Some Excel tips will help you instantly become more productive, or use Excel more efficiently. Click through to see our top 10 Excel tips. … [Read more...]

Pages: 1 2 3 4 5 6 7 8 9 10 11

7 Excel Formatting Tricks

June 18, 2014 by Mark 1 Comment

Paste Excel Formatting

Microsoft Excel, like any other Office product offers it's users simple and intuitive ways to format your data. Many of these formatting options are great for using once or twice, but what if you find yourself needing the same format dozens of times, or need a format that doesn't exist? The following Excel formatting tricks will help you work more efficiently. … [Read more...]

Pages: 1 2 3 4 5 6 7 8

3D Sum Formula Reference

June 12, 2014 by Mark 2 Comments

3D Sum Range

On occasion, it is useful to keep track of similar data in separate worksheets. Data such as monthly, quarterly, or annual financial information isn't always best to show in one spreadsheet. However, there may be times when you want to see a total of the data on each worksheet. The 3D Sum Formula will let you easily add up data across the worksheets without having a long … [Read more...]

Next Page »
Subscribe to our mailing list
  • Facebook
  • Twitter

Search this site…

Categories

  • Macros (34)
  • Tips (67)
  • Uncategorized (23)



Copyright © 2023 · Magazine Pro Theme on Genesis Framework · WordPress · Log in

Login Form

Lost your password?