Showing posts with label print. Show all posts
Showing posts with label print. Show all posts
Sunday, October 16, 2016
How to Print Headings on Every Page in Excel
How to Print Headings on Every Page in Excel
Sometimes you may need to print same column headers on every page in Microsoft Excel. And to do so, you dont need to manually copy the headers on every page. You can simply set a command from page setup option to print column headers on every page automatically!
In my previous post, I discussed about how to lock or freeze column headers. By freezing rows or columns, you can just show headers at the time of scrolling. But they will be printed on the first page only. In this tutorial, you will learn - how to print same column headers on every page automatically . . .
Applies to:
- MS Excel 2000/ XP
- MS Excel 2007/ 2010/ 2013
Note: This tutorial has been prepared using Excel 2013. So, few options may differ slightly.
Lets start -
- Open a previously saved worksheet or create a new one in MS Excel.
- Go to the Page Setup option from Page Layout Tab (Office XP/ 2000 users should find it under Edit Menu).
- Go to the Sheet tab from Page Setup.
- Look at the Print titles option: Rows to repeat and Columns to repeat.
- To repeat the headers at the top, click on the first one. Or click on the second one to repeat the columns.
- After clicking the box, select the area of your sheet which needs to be repeated. Follow the image below.
- Hit OK to close the Page Setup. Done! Now check by printing or look at the print preview.
Here I showed the process for rows only. You can also choose columns to repeat by the same way. And Ive also uploaded a same sheet for you. Download the sheet from the link below:
Download Sample Sheet - Rows to Repeat
Open the above sheet. You will find a worksheet named Rows to Repeat. Ive set top 3 rows to be repeated on every page. You can directly check it by printing this two-page worksheet. Or simply check it in Print Preview.
Hopefully, todays topic will be helpful for your study or office work . . . :)
Stay with Marks PC Solution to get more interesting IT topics!
Go to link download
Friday, October 14, 2016
Free Print from Android Cam 1 7 torrent download
Free Print from Android Cam 1 7 torrent download
Print from Android Cam
Productivity
[Download Link >>]
version:1.7
rating: 3.3
rating count: 646
updated: 2015-01-17
size: 1.3 MB
installs: 1000
cost: UAH13.75
Go to link download
Print Screen Button Tips
Print Screen Button Tips
Each and every computer users are familiar with the Print Screen Button. Most of you know, you can take a picture of your screen through Print Screen button. In your Keyboard, you may notice the button as this name - Prt Sc/SysRq.
Do you know what is SysRq? Its an acronym for System Requirement which is a command used by Linux Kernel. To be honest, I know nothing about the use of SysRq. And in a Windows PC, this button has no standard use.
Using the Print Screen Button Smartly
Almost all of you can use the Print Screen button. But how many of you can use this button smartly? Not many people! :)
Print Screen
If you press this button, the picture of your screen will be sent to clipboard. Then you can paste the image in a program that allows you to paste images. Such as - Paint, Photoshop, MS Word etc.
Example - I pressed the Print Screen button and paste the image in Photoshop. Now you can see the picture of the whole screen including task bar.
Alt + Print Screen
Suppose you dont need the whole screen. You just need the picture of your currently running screen or program. In that case, you can press Alt + Print Screen button.
Example - Ive just opened Google Talk. Then pressed Alt + Print Screen and then paste it in Phtoshop. Only the picture of Google Talk has been pasted there.
Windows + Print Screen
Almost do the same job as Print Screen. But this time you dont need to paste the image anywhere. If you press Windows + Print Screen button at the same time, your monitor will blink for a moment, the image of your full screen will be saved in your picture folder automatically.
Just go to My Computer > Then hit on the Pictures from Left Panel > Now you will get a folder named Screenshots > All pictures taken by Windows + Print Screen button will be saved here.
Related Posts
- Take Screenshot by Snipping Tool
- Capture Screen by Microsoft Word
Stay with Marks PC Solution to get more interesting IT topics!
Go to link download
Sunday, September 11, 2016
HP LaserJet Pro M1132 MFP Print Scan Copy!!!
HP LaserJet Pro M1132 MFP Print Scan Copy!!!
If you would like to buy a laser printer, I will recommend you to purchase HP LaserJet Pro M1132 MFP. With this device, you can print and scan your necessary documents. You can also use this device as Mini Copier! I mean, you can use this device to copy documents without connecting it to a PC - this is really cool!
Background Story
More than 2 years ago, I purchased a color printer costing $ 60 - Epson T13. It was running smoothly. But it was unused for few weeks. Consequently, the printer head was damaged. Then I repaired it costing $ 50. Couple of weeks ago, it was damaged again. Then Ive decided - no more InkJet printing!
When I went to my dealer for buying a duplex printer and scanner, he advised me to purchase HP multifunctional printer.
Since this device has both copy and scan facilities, I havent purchased the duplex printer. Yesterday, I purchased HP LaserJet Pro M1132 MFP costing more than $150.
Product Specifications - M1132 MFP
Control Panel Features
At the left side of the printer, just above the power button, you have a control panel. With this panel, you can increase or decrease the amount of ink. And you can also increase and decrease the print size and set the number of copies.
By default, the control panel display is fixed with the printer body. But you can fly this out by pulling.
Product Specifications - M1132 MFP
- Multifunction - Print, Scan & Copy
- Cartridge - HP LaserJet CE285A Black
- Height - 9.8 Inch , Depth - 10.4 Inch, Width - 16.3 Inch , Weight - 7 KG
- Paper Tray Capacity - Both input and output tray can handle up to 100 sheets
- Supported Paper Sizes - Letter Size, Legal Size, A4 etc.
- Print Speed - Up to 18-Page Per Minute
- Resolution - Up to 600 Pixels Per Inch
For more specifications, follow this link . . .
Limitations -
- Automatic duplex printing is not supported!
- Scan quality is not 100% satisfactory.
Control Panel Features
At the left side of the printer, just above the power button, you have a control panel. With this panel, you can increase or decrease the amount of ink. And you can also increase and decrease the print size and set the number of copies.
By default, the control panel display is fixed with the printer body. But you can fly this out by pulling.
If the Driver CD is Lost?
Nothing to worry about - with HP Smart Install feature, you can install the printer even without driver CD! And if you badly require the printer driver, you can get this here -
HP Printer Driver
After visiting the above link, you will get your operating system selected automatically. Or you can choose a different operating system. Then download your driver.
Stay with Marks PC Solution to get more interesting IT topics!
Go to link download
Saturday, August 27, 2016
How to Print Word Document as Booklet
How to Print Word Document as Booklet
You can print your Word Document as book. In MS Word, the term is known as Book Fold which can be found in the Page Setup dialogue box. If you want a document to be printed as a booklet, you must set up the document at first. Otherwise your document settings may change too much. And this will take a huge time to fix the settings.
For last few days, Ive published several posts on Excel. Now its time to write something on MS Word. What do you think? :)
Applies to All Versions of MS Word
- Word XP, 2003
- Word 2007, 2010, 2013
What does Book Fold Do?
Its a good question to begin the discussion. Suppose you have a document with 4 pages. If you want the printed document to be looked like a book, you can use the booklet option. The Word will print your document as show in the image below:
And if you print the two pages in both sides of a single paper, it will be like a book! What if you have 8 pages? Then it will be printed as below:
That means the last page of the document will be printed with the first one. Then the second page and the second last page will be printed together. Thus the series will continue. Even page will be printed on the left side and the odd page will be printed on the right.
In a 8-page document, you have to use 2 papers only. Page 8, 1 and 2, 7 should be printed on the both sides of a single paper. Then page 6, 3 and 4, 5 will be printed on another paper. The second paper should be folded in the first paper if you want the document as book.
The concept of booklet is little bit tough if you have no practical experience. So, I suggest you to try it directly if you have a printer. :)
How to Use Book Fold?
If you use Book Fold after completing your document, you may suffer a lot. Because it will change your text or graphics position. So, if you have any intention to print the document as book, your should set your document as Book Fold when you set up the page.
Follow the steps below:
If you have any confusion, please leave a comment . . . :)
How to Use Book Fold?
If you use Book Fold after completing your document, you may suffer a lot. Because it will change your text or graphics position. So, if you have any intention to print the document as book, your should set your document as Book Fold when you set up the page.
Follow the steps below:
- Open a document or create a new one
- Go to the Page Setup option from Page Layout Tab (In Office XP, 2003: File > Page Layout)
- Margins > Pages > Multiple Pages > Choose Book Fold
- Sheets per Booklet > Choose All
- Hit OK to exit. Done!
How to Print Booklet?
You must know the right way to print a booklet properly. If your printer supports automatic both side printing, the task will be much easier for you. But if it doesnt, then you have to print both sides manually.
Go to the Print options > Print on Both Sides (Flip on Short Edge)/ Manually Print Both Sides > Landscape Orientation > Hit OK.
If you have any confusion, please leave a comment . . . :)
Stay with Marks PC Solution to get more interesting IT topics!
Go to link download
Subscribe to:
Posts (Atom)