Aug 20, 2012 Regarding the 'blue lines'. You can toggle between Normal view and Page Layout view (in the bottom left corner). That will make the 'blue line'. ![]() Here’s a common question about Footnotes in Word. “When I insert a Footnote into my Word document a separator line is automatically inserted above the footnote reference. How do I remove the footnote separator line?” It’s a bit of a process to get rid of it. Let me show you how. Removing the footnote separator line • First from the References tab insert your Footnote. By default a separator line will be inserted above the Footnote text. • Now change your document view to Draft. From the View tab click Draft. • If the Footnotes pane isn’t visible click Show Notes on the References tab. • From the Footnotes drop-down list select Footnote Separator. • The pane will display the separator line. • Select the separator line and press DELETE. • Now change the document view back to Print Layout view. • Your footnotes will now be displayed without the separator line. If you would like to change the length or style of the separator line go back to the Draft view, select the Footnote Separator option and then select the formats and style you want applied to the separator line. We cover footnotes, end-notes, cross-referencing and creating Tables of Contents in our courses. If you found this post helpful please ‘Like’ us! 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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2019
Categories |