How to Insert or Edit a Bookmark in Your PDF File?

Bookmarks can be extremely useful. We use them to mark certain pages in a document, which helps us find what we need faster.

Numerous PDF readers support viewing bookmarks, but not many of them are able to modify them or create new ones. Usually a premium software is required for that purpose.

However, there is one PDF reader which allows just that. It is called PDF X-Change Viewer. You can use it to work with bookmarks pretty easily.

First, once you open your document in this reader, you need to make the bookmarks bar visible. Go to View – Bookmarks.

view bookmarks in PDF

After that go to the page you want to mark, and in the left sidebar click on the plus sign to create a bookmark there. You can add as many as you need.

create new bookmarks

You can also edit existing bookmarks. Right click on one, and a new menu with multiple options will appear.

By going to Bookmark Options, you can also change the default color or assign some specific actions like opening a URL, for example.

rename delete modify bookmarks

At the end, save all the changes, and that would be all. Newly created bookmarkes will be visible in any other reader.

The Best Places to Learn VBA Online

Your knowledge of Microsoft Excel is not complete until you’ve learned the VBA language. Knowing VBA can help you automate repetitive tasks easily. Furthermore, if you know how to code, you’ll be able to spend only an hour or less on things that you previously needed a whole day to do them manually. That is why the knowledge of VBA can be very useful in the business environment.

It is important to bear in mind that one can’t learn it simply by reading tutorials on the Internet. A lot of the learning process happens through practice: recording macros, reviewing code and creating and solving minor problems.

microsoft visual basic for applications

In order to help you with that, we have created a list of the best websites to use to really learn VBA.

1) Free VBA MOOC

This course is appropriate and useful for beginners. It helps you learn the most important concepts in VBA programming.

2) VBA on StackOverflow

StackOverflow has a special section dedicated to VBA, where you can post your own problems, follow questions and dilemmas by other users and also engage in helpful discussions.

3) VBAisFun

This excellent Youtube channel is a stop you shouldn’t miss in your learning. Many complex problems are explained here step by step. Kudos to the guy who created it.

4) Reddit VBA community

A subreddit dedicated solely to VBA problems and solutions. You can find a lot of useful advice by going over past threads.

5) Learn VBA programming

This is another useful Youtube channel where both basic and more advanced topics are covered.

6) Homeandlearn

This website features nicely explained VBA tutorials and useful pieces of code.

7) Excel Pratique

This is yet another useful website with downloadable exercise spreadsheets.

8) Chandoo VBA

A set of very nicely explained tutorials.

How to Debug Your VBA Code in Excel?

When code is not working as it should, it can be hard to locate the error if you have multiple lines of code. Hours can be spent searching for the mistake, without success. To avoid such situations, it can be helpful to use some of the debugging tools that come with Microsoft Excel.

Run Code Step by Step

It certainly won’t be easy to find the problem if you run your code all at once. Running each step of the process one by one can help you identify where the bottleneck is. Here’s how you can do it.
Open your code, select the first line and press F8.

vba steps one by one
The line will turn yellow. Press F8 once more and the yellow mark will move to the next line. Every time you press F8, the next line will be executed. If you have loops in your code, each step in the process will be executed one by one. For example, if you have 100 iterations, you will be able to follow each of them. This process can be extremely useful in testing and running your code.

Pause Code Execution

While testing a pretty long code, sometimes you want to pause and inspect what has been done thus far. To do that you need to select a line of code which will serve as pause, and press F9 or click on the Toggle Breakpoint.

create a pause in code
Once you click Run, the code will make a pause there and you can investigate your variables and output value. All pauses are marked with dark red color. Make sure to delete them after you have finished debugging.

Immediate Window

After you have paused your code, you can do some more experimenting before continuing. You can do that in Immediate Window. To turn it on, go to View – Immediate Window.

immediate windows in excel
Here you can print the value of all variables or perform some more commands outside the main code for your own testing.

paused code experiments

There are other advanced ways for code debugging, but for beginners this will be more than enough. The need for debugging will occur often, which is something that every developer will tell you.

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