by John MacDougall | Sep 15, 2022 | General
Do you need to randomize your data? This post is going to show you all the ways you can randomly sort a list in Excel. Sorting data is usually a key component of any data analysis. It can help you organize your data, spot trends, or find the minimum and maximum...
by John MacDougall | Sep 13, 2022 | Format
Do you work in finance and need to apply the accounting number format to your data? This post is going to show you how to add the accounting format to your numbers in Excel! Excel offers users a variety of number formatting options. This is because there are many...
by John MacDougall | Sep 12, 2022 | General
Have you ever wanted to keep a row or column fixed in view while scrolling through your data? This post is going to show you how to freeze rows or columns so they always stay visible. You will often need to scroll down or to the right to view a particular record or...
by John MacDougall | Sep 9, 2022 | General
Do you want to turn off the scroll lock? This post is going to show you how to disable the scroll lock feature in Excel. This might be something you have accidentally enabled and don’t understand why your Excel is not scrolling normally or why the arrow keys...
by John MacDougall | Sep 8, 2022 | Format
Do you need to clear all the formatting from your data? This post will show you how to remove all formats from a selected range in Excel. Formatting is key to making your Excel workbooks look good! However, too much formatting can become a distraction. When this...
