How Do You Number A Column In Excel For Mac

Sometimes you have a large list that contains empty rows, and you need to remove these rows in order to clean up the list. You could delete the rows one by one, but that's going to take a long time, especially if you have lot's of blank rows. In today's ExcelJet tip, we'll show you a cool way to delete blank rows, even hundreds or thousands of blank rows, in record time. Even better, with this tip, Excel does all the hard work for you. Let's take a look.

Here we have a really big list that contains a lot of empty rows. If we hop down to the bottom of the sheet, then back up to the bottom row, we can see that we have over 36,000 rows, and several thousand of these rows are empty. Sure, we could just work our way through the list, deleting those empty rows one by one. But that will take a long time, and it won't be any fun at all.

If you have a column of numbers that you want to turn into a row, Microsoft Excel has a very useful function to do just that for you with minimal effort. Select the columns you’d like to transpose and hit Ctrl+C or Edit > Copy. When you need to assign consecutive numbers to rows or columns in Microsoft Excel 2010, it can be very frustrating to do it manually. Aside from the amount of time that it can take, it is very easy to make mistakes, forcing you to go back and re-do your work.

So let's look at a really fast way to do it using Excel's GoTo Special command. To start off, select the entire first column. Then select Edit > Go To., and click the Special button. Select 'Blanks' and click OK. Excel has now selected all of the blank cells in our first column. Now carefully right-mouse click on one of the empty calls, and choose Delete. From the menu.

Then select Entire row, and click the OK button. Now we have a clean list with no blank lines. If we hop down to the bottom of the list, there are a little more than 33,000 rows, which means we just deleted over 3000 empty rows! In a future tip, we'll show you how to use this same approach to remove non-blank rows with missing values.

See you next time.

Industry Editions (,,, ) 60 Day Money Back Guarantee QuickBooks Enhanced Payroll *Optional Hosting QuickBooks Desktop Enterprise with Hosting keeps everything in the cloud, not on your office computers. Includes a free 1 year subscription for every Enterprise User you buy to Fourlane's online QuickBooks training courses. Quickbooks usesr interface for mac. Right Network’s application hosting & Cloud Computing allows businesses to deliver the full power of desktop and server-based software to their employees, franchisees, and accounting clients in a monthly, per-user Software-as-a-Service (SaaS) model. Manage your business from wherever you want, whenever you want, and from whatever devices you have. We’ve partnered with Right Networks to provide you with remote access to a protected environment for your QuickBooks software.