How to Convert a Webpage to PDF Format on Your Android Phone?

When we browse the Internet, we come across multiple interesting websites and articles that we sometimes want to save for later reading. We’ve already mentioned several times that the best format for storing documents is the PDF, because of its compactness and ability to look the same across all operating systems. In line with that, we want to show you how to convert interesting web articles to PDF by using Mozilla Firefox and Google Chrome for Android. This way you can read what interests you even when you’re offline.

1) Google Chrome

It is fairly easy to convert a webpage to PDF using Google Chrome. Simply choose the Print option from the main menu.

print google chrome

In the above menu, as you can see in the image, choose Save as PDF for the printer. Click on the PDF button, and your file will be saved in PDF format right inside Google Drive.

save as pdf google chrome
This is also an excellent way to convert the document later into one of the Office formats by using Cometdocs Google Drive extensions.

2) Mozilla Firefox

If you prefer to use the Firefox browser on your device, the conversion is again very simple. First open the webpage you want to print into PDF files.
Tap on the small icon in the address bar that will make the webpage more readable. This will remove all the ads and unnecessary content on the webpage.

better printing in mozila firefox

Also, if you click on the menu below, you will be able to change the font size, background color and more.

adjust font

Now tap on the Menu button and choose Page.

page option mozila firefox android

After that click on Save as PDF. Choose the location of your new PDF file and save it.

save as pdf
As you see, the whole process is very easy and we hope you’ll like converting web pages to PDF.

How to Make Notes in the Sidebar of PDF Pages in OneNote?

Many books and documents we deal with today come in PDF format. Reading PDF files is pretty easy, but sometimes we want to make notes while reading. You can easily make notes directly in PDF with any of the readers. We have already explained how to do it in Adobe Reader. But, that would require making direct edits in the document itself. There is another way to do it, and it involves using OneNote. This program allows you to make notes right next to each page of your PDF document.

Here is how you can do it. Assuming that you already have OneNote installed, open your PDF, go to the Print option and choose Print to OneNote.

print to onenote

The document will be transferred to OneNote, and you’ll be able to choose which notebook section to transfer it to. Note that it might take a while for large documents. Once transferred, each page in the document will appear as a separate page in the chosen section.

note taking in pdf onenote

You can choose any page you want, and there will be an empty space in the sidebar where you’ll be able to make notes, as you see in the image.

After you’ve finished with your note taking, you can convert the whole document back to PDF along with your notes by going to File – Export – Section – and choosing the PDF format.

Export secton notebook to PDF

How to Comment/Uncomment Multiple Lines of VBA Code in Excel at Once?

Writing VBA code in Excel has many challenges. Sometimes we test and experiment with large blocks of code. In such cases it would be useful to have an option to comment or uncomment multiple lines at once. Otherwise, if we do it line by line, we can waste a lot of time.

This tip can actually save you a lot of time and energy. All you have to do is to select all lines of code you want to comment or uncomment.

To make this option visible go to View – Toolbars – and tick the Edit option.

edit toolbar

A new set of options will appear in the toolbar.

comment vba code
Among them you will find the Comment/Uncomment buttons, as you can see in the image.

This option can save you from hassle and wasting a lot of time when writing and experimenting with code, and many developers have overlooked it. It is always much easier to work with blocks of code, than having to comment or uncomment a single line by line.

Best Websites with Microsoft Word Templates

Microsoft Word is one of the most widely used textual editors for creating different types of documents, such as press releases, letters, books, resumes, reports and more. Many people use Word on a daily basis for work. Once they start working on a document, beside content, they also have to worry about its design and visual appearance, especially if the document needs to be forwarded to somebody. A nicely structured report, memo or CV will always make a better impression on a boss or colleague than a poorly structured one.

If you are not particularly skilled at designing the reports yourself, you can always use premade Word templates, which can save you time and help you create a professionally looking document in a second. The additional benefit of using templates is that you don’t have to start from scratch, because they provide basic elements you can work with.

Here are some websites that contain excellent templates for various purposes, from budget, educational and project to CV templates. There is a little bit of something for everybody, regardless of what type of documents you usually work with.

1) Microsoft Office 

search for online templates

The Microsoft Office website is probably the first place you should visit. In many cases you will immediately find what you need, because the choice is pretty wide. MS Word templates are divided into more than 30 categories ranging from Agendas, Invoices, Minutes and Photo Albums, through Timelines, Calendars, Maps and Menus, to Posters and Flyers. You can search for new templates right inside the Microsoft Word 2013 interface, as you can see from the image.

2) Hloom Templates

free microsoft office templates

Hloom is another site with a lot of free templates for Word. They are divided into categories and subcategories. All of these templates look pretty modern. We especially recommend the Resume and Flyers section.

3) Vertex Templates

word templates vertex

The Vertex website has a couple of completely free and pretty useful templates. All of them are mostly oriented towards business use and career improvement.

4) Powered Template

This website doesn’t have a big choice of free Word templates, but some templates are pretty interesting and it’s worth checking them out.

word

How to Record a Macro in Excel – a Step-by-Step Guide

Macros in Excel present automated steps that we can repeat whenever we want. They are often used for performing repetitive tasks, which significantly saves time, and also when learning VBA.
Here are some tips on how to start working with Excel macros. It might look hard at the beginning, but with more practice, you will be amazed with all the possibilities.

1) Enable the Developer tab

The Developer tab, from which all the developer and VBA functionalities are offered, is hidden by default. Here is how you can make it visible.
First go to File – Options.

excel options tab 2013
Choose the Customize Ribbon tab and check the Developer option in the main ribbon.

customize the ribbon in excel 2013
Now, the new Developer tab will appear in the main menu.

the developer tab in microsoft excel

2) Record a macro

In the new Developer tab there is a button Record a macro that starts the recording. Turn on the button and start recording.

record a macro

3) Use relative references

If you regularly use Excel, you are probably familiar with relative references that are often used in Excel. Macros can be better implemented in the future using relative references. So, in this case we suggest starting from the field A1 and turning the relative reference field on while recording.
Next time you want to repeat the macro steps, you don’t have to worry if you entered a value in the cell A1 or cell B2; the macro will perform all other steps relative to the first field.

relative references when recording macro

4) Name and description

It is of utmost importance to enter a good and detailed description of what a macro does, along with an appropriate name, because once the number of macros pile up, you won’t be sure which macro is for what. Prevent this by entering macro descriptions in great detail.
Also, if you plan to reuse it for other documents, make sure that the macro is saved in your personal space.

macro name and description

5) Edit a macro

how to edit an existing macro
Sometimes a macro needs to be edited after recording. This is easily done by going to the Macros section, choosing the relevant section and clicking on Edit. The Step into field is useful as well, because it allows you to see all the steps in the VBA code and analyze them if you need.
If you receive an error that a workbook is hidden, go to View – Unhide and choose the Personal macro workbook.

unhide excel macro edit

Now you will be able to edit or delete existing macros.

6) Run a macro

run a macro
To run a macro, all you need to do is to choose it from the list and click Run. Have in mind that whenever you record a macro, before closing the Excel completely, you need to save all changes made to the Personal workbook. This way all macros will be saved and available for later use.
There are other ways to run a macro, like using buttons or other features, but we will talk about it in our future articles.