To make your printed Excel documents look more stylish and professional, you can include a header or footer on each page of your worksheet. So microsoft tech support, the above is what happens when you try to find solutions rather than duck out of work.Do you want to know how to make a header in Excel? Or are you wondering how to add the footer page 1 to the current worksheet? This tutorial will teach you how to quickly insert one of the predefined headers and footers and how to create a custom one with your own text and graphics. You can link the table to the original spreadsheet so it can update. Oh, and speaking of word, possible option 5, annoying as heck, paste your excel data into a word document as a table. Unfortunately Word does not seem to be compatible with excel-in a way it should be! (unavailable) method 4, make the line in a microsoft word header and copy/paste it into your header. The requires a good eye and some time, but you can make any line you want!
Then insert>shapes and pick the line, draw it to your best ability and then go into your print preview again and see how close you are, repeatĪs needed. Method 3, tricky but powerful, make your footer, go to print preview, gauge how far up/down you want your line. Method 2, multiple underscores, downside is that it has to be at the bottom of a line, which pushes your text lower. Method 1, multiple dashes - Downside is that it is clearly dashes. If you want to be told that what you want to do can't be done, ask Microsoft!Īnyway, there are three ways I found, and a forth way I found doesn't work only because word is not compatible with excel?!?!?! Order to improve our services through the upcoming updates.Īs always, your inputs are highly appreciated. This page is where our development team get ideas in You may share all of your suggestions through this link. What we can do now is toĪdd, change and edit headers and footers. We have looked into your case and found out that the option to add horizontal line in the headers and footers is not available yet.
0 kommentar(er)
