How to Split Cells in Excel

When working with Excel, you may encounter many difficulties that will slow down your work. Luckily, there are many Excel tips available online and you can find them and use them very easily. Whereas solutions to common Excel problems can be found quickly, solutions to those less common Excel problems are harder to find. One such difficulty you may experience while working with tabular data is to split cells in Excel. Oftentimes wrong data is placed together in one cell and you need to make more cells in order to split that data.

Unfortunately, there is no such option in Excel that can divide one cell into multiple smaller cells but still, there is a way to split cells in Excel. If you follow the steps below you will be able to divide content and place it in separate cells.

Firstly, select the cells you want to split. By clicking on the Data menu, a toolbar like this one shown on the image below will appear.

split cells in excel

In the Data Tools tab, click on Text to Columns and then on Delimited option. When you click on Text to Columns, a window will show up asking you to choose between Delimited and Fixed Width.

split cells

Then click Next and another set of options will appear.

At the top of the window you will see a set of delimiters options, and you should tick one delimiter  that is the most suitable. You can choose more than one delimer and in that case, tick the box Treat consecutive delimiters as one. The data preview panel shows how the data will look like when it is split in multiple cells.

cells in excel

When you click Next button one more time, you will be able to format column data, by setting up the options in Column data format area.

split cells

When you are done with formatting just click the Finish button.

Additional notes:

If you are working with big data it is required to make a copy of the spreadsheet first and then to split cells in Excel.

If you are asked to replace the content of destination cells, cancel that operation, select different delimiter and modify data in the original column.

No matter how often do you work with Excel, learning new Excel skills can only help you with data analysis and other data manipulation tasks.

 

 

 

 

How to Add Page Numbers in Word

Many Microsoft Word users don’t know how to add page numbers in Word. Even if they knew how to insert numbers, the problem arises when a document would have the introduction or a table of contents. That first introductory part of the document shouldn’t include numbers which means that a user must skip a couple of pages at the beginning. Since Word has automatic number labeling, a user must set up page numbering manually.

The following guide applies to Word 2016, 2013, 2010 and 2007. First, we will show you how to add page numbers in Word and then we will share with you some advanced techniques.

 

Guide 1: How to Add Page Numbers in Word

 

First, open the exact page in the document from where you want to start page numbering. Then click on Insert menu and then on Page Number option in the Header & Footer tab.

insert page number in word

You can have a closer look at the Page Number option, on the image below.

how to add page numbers in word

 

You can add page numbers at the top or bottom of the page, page margins or from the current position. For instance, if you click on Top of Page, a wide range of numbering styles will appear and you need to choose from one of these.

 

Guide 2: Add Page Numbers in Header or Footer

 

If the header or footer of your document contains text such as the name of the book chapter or the head name and you want to add page numbers as well, the above guide won’t be of any help. For that purpose, you need to apply a bit complex settings.

First thing first, double mouse click on the header of footer area and the Design menu will open. Click on it and then in Position tab, select Insert Alignment Tab.

header and footer tools

 

You can place your numbers on the left, right or centrally. Below is shown how the Alignment Tab looks like.

 

add page number

 

Don’t close the Design mode but select the Quick Parts option from the Insert tab. Choose Field option.

 

quick fields

 

In the field name find the Page and then in the Field properties choose the proper number formatting.

 

page number formatting

 

Click OK and then close the Header and Footer tools.

 

Guide 3: Set up Page X of Y Format

 

Follow the guide 1 to insert page numbers and upon choosing the location where you will put the numbers, choose the style. One of the styles is Page X of Y which offers three different types of bold number.

If your header or footer contains additional text, you need to follow the guide 2 and upon opening the Quick Parts tool and Field option apply these steps below:

Under the Field names list, choose NumPages name and then click OK.

From the Header & Footer tab, select Format Page Numbers and then choose the preferred format of numbers.

 

choose number format

 

Guide 4: Use Different Numbers Formats in the Same Document

 

Follow this guide if you want to use different number formats such as i, ii, iii and 1, 2, 3. Click on the page in the document where you want to start page numbering with different format.

From the Layout menu, in the Page Setup tab, select the Breaks option.

In the Section Breaks click on Next Page and then double click in the area where you want to insert a number.

The Design tab will open again and this time, you should click on Link to Previous button. By doing so, you will unlink the page numbering from a previous section and this part of the document will have different page numbering.

To set up the new format of page numbering, just follow the guide 1.

 

Start Page Numbering with Different Number

 

In some cases,  you may want to use some other number as a starting number and not the number 1. Following these steps to start page numbering with a different number:

Click on the Format Page Number option in the Header & Footer tab.

In the drop-down menu Start at, type the number you want to be your starting page number.

 

page numbering in word

 

How to Embed a YouTube Video in PowerPoint

With over 30 million presentations created every day, Microsoft PowerPoint is without any doubt the most popular slideshow creator on Earth. Used extremely frequently both in business and in education, this software allows users to expeditiously manage their presentations, which can later be applied to a wide array of possibilities.

Another interesting fact is that 120 million people use PowerPoint for business, and more than 6 million teachers depend on it for classroom lectures. A relatively new feature to PowerPoint is that you can embed YouTube videos onto a presentation, which can be more than convenient at times.

As the world’s largest free video hosting service YouTube doesn’t really require any kind of special introduction, so if you require embellishing your presentation with a YouTube video and you’re not sure how to do it, continue reading this post!

 

So, how exactly to embed a YouTube video in PowerPoint?

 

Firstly, it is important that you own a 2016, 2013 or 2010 version of PowerPoint, because otherwise the embedding won’t work.

 

  1. The beginning step is to open the YouTube video you require embedded with your browser. It’s also vital to note that YouTube is the only streaming website that is supported by PowerPoint, so you cannot use other stream-based sites.
  2. Select the Share option on that specific YouTube page. You will find the Embed button exactly below it. Just copy the highlighted code (with the right click mouse button, or with Ctrl+C on your keyboard).

how to embed a youtube video in powerpoint

  1. Open PowerPoint and select the specific slide you wish to add the video on. Click on the Insert tab, where you’ll see the Video button among other options.

embed video in powerpoint

Click on it and select the Online Video option. In case you’re using the 2010         PowerPoint version, click the Video from Website button.

  1. The next step is to select the Paste embed code here option, or you can just use the Ctrl+V, or right click your mouse and press Paste. Then click on the arrow to insert a video into PowerPoint.

how to embed a youtube video

  1. Once you’ve completed these steps, the video will emerge on your slide. Most probably it’ll just appear like a black box, but do not fret, because this is normal.
  2. The next phase is to select the Playback tab, which will open all the options for the video. Click the Start drop-down list and choose how the video will play. It’s very important that you select one of these given options, because the video won’t work without it.

insert video in powerpoint

  1. When you are planning to present your PowerPoint presentation, make sure that you have a reliable Internet connection, which is a mandatory requirement for the YouTube videos to be played.

Tax Day 2017 PDF Software Deal- 20% Discount

tax day deal

With this year’s tax season almost at a finish, there is only a narrow time frame to get all of your taxes in order. If you don’t perform these types of activities as a professional accountant, it’s probably safe to say that you’ve left with this (let’s not fool ourselves) quite difficult and exhausting task for the last moment possible.

Analyzing huge amounts of documents can be a real hassle, especially if it has to be done in a very short period of time. To make things even worse, the majority of these tax returns, invoices, bank statements and other similar accompanying documents frequently come in PDF form, which makes them severely tough for editing.

In light of all this, we wanted to help everyone in need by lowering the price of our software, PDF Converter Elite 5.

 

You can use this 20% discount from today to April the 18th.

 

 How PDF Converter Elite Can Help You With Financial Data

 

 

With PDF Converter Elite 5 you can easily do almost anything with your PDF files:

  • edit text directly on a PDF
  • custom convert PDF to Excel and CSV
  • secure files with passwords and apply permissions only to the certain people
  • convert both regular and scanned PDF files
  • merge PDF files or pages
  • split PDF files or pages

Take advantage of this time-sensitive offer and make this tax season passes with lower stress levels than usual!

How to Rotate PDF Files

Performing classical editing options on a PDF file can be quite troublesome because of their read-only nature, and one of them is definitely the rotation of the entire document, or just specific pages of the document. The reasons to rotate PDF files can be numerous, ranging from either the need to fit a specific screen type, or rotating only the pages that have images (or graphics) on them, while preserving the original outlay of all the other pages. We shouldn’t focus too much on possible intentions for rotating PDFs, because each individual has their own unique requirement to do it, depending on the file in question, instead we should concentrate on how to overcome this distinctive, but fairly simple issue- to rotate PDF files.

 

Rotate PDF Files by using PDF Converter Elite

Download the free trial version of the software here, and once you’ve installed it on your computer, open the PDF you require to be edited. This is achieved by selecting the Open icon found on the upper left part of your monitor.

 

rotate pdf files

 

Once the file is selected, the next thing needed to be done is to open the Edit window, which is also found in the upper left corner.

 

rotate pdf

The Edit subsection offers multiple choices, and to rotate your PDF, click on the Rotate Pages button.

rotate pdf pages

 

Here you can determine the starting and finishing page you desire rotated, and the angle of the rotation itself. You can choose from 90° clockwise, 90° counterclockwise, and 180°. If you require to rotate multiple pages that don’t go in a row, just repeat this step again.

 

rotate pdf file

 

So there you have it, hopefully this short tutorial will aid you once you have the need to edit your PDF file in this somewhat unusual, but very useful way. For more PDF tips visit our PDF knowledgebase here.

 

How to Delete Pages from PDF

Working with big data can be exhausting and time consuming. Often those files that you need to analyze are kept in PDF format, which is known for its capacity to keep the document protected. That comes in handy for document safety purposes, but if you want to get rid of some parts of the document you will need to learn how to delete pages from PDF files.

If you deal with large PDF files, the only way to process all that data is to delete unnecessary pages. In a few steps you can get rid of information you don’t need and have a better organized PDF document.

 

Use PDF Converter Elite to Delete Pages from PDF Files

 

Install a free trial of PDF Converter Elite here.

Upon running the program, open the PDF file you are working with. To open a PDF file, click the Open icon or File > Open.

Delete Pages option is accessible via Edit button shown in the toolbar. You can also access the Edit options by clicking on Edit menu.

If you click on Edit button on the toolbar, a sidebar will show up on the left offering you different editing options. One of them is Delete Pages button.

delete pages from pdf

If you choose to click on Edit menu, a drop-down menu will appear where you will find Delete Pages option.

Note: This option is only available if your PDF contains more than one page.

 

So, what is the next step?

Continue reading >>

How to Insert a PDF into a Word Document

Regardless of your job occupation, document management is an inevitable part of every work day. If you often work with MS Office documents such as Word, Excel or PowerPoint, you probably know that there is an option to insert different objects into that document. Not only can you add illustrations and tables, but you can also add images and PDF documents. It is particularly convenient when you want to add data from a different document. Since most documents are preserved in PDF, converting that PDF to Word and then copying the data in Word document you are working with, can result in losing the formatting. Moreover, it can altering the formatting of the working document as well. For that reason, it is more safe to insert PDF into Word. To do so you just need to follow the instructions below:

Insert PDF into Word

 

Open a Word document you are working with and click on the Insert menu. It is placed next to the Home menu.

ms word insert menu

Click on the Object button and then on Create from File tab. You will find Object button in the Text tab as shown on the image below.

insert pdf into word

When you open the Object window, it will look like this:

Continue reading >>

News: PDF Converter Elite Has Received Another Reward

With the release of the new version of PDF Converter Elite, we have received many compliments on the software and its performance. We would like to thank all the bloggers and other software review experts who found our software worth of reviewing. Apart from positive notes, we also received a reward from software review website Holyfile.

software award

Here what they said about our software:

“What we discovered in PDF Converter Elite 5 that could be useful for us?

When you want to send a file and make sure the format doesn’t change on the other computer, you’ll send it as a PDF file. This way you always keep the layout professionally looking. It’s a simple thing, but it really matters when you want your presentation to look good. It could mean the difference between a promotion and a demotion. The great thing about the program is that you can split and merge PDFs and even scanned PDFs can be converted. There are some PDF converters available on the internet, but none as good as this one.

This is why we have given the Holyfile award:

PDF Converter Elite 5 has proven useful in many ways to us. As we often make sure to save documents as PDFs to make sure others can’t edit the content, we also experience the struggle when we see a spelling mistake or we want to edit the document ourselves. That means we’ll have to find the original Word or Excel document, change it there, save it and convert it to PDF again after we correct the error.

PDF Converter Elite 5 has made this much easier as you can now edit directly in the PDF document. As it’s also a simple program with a detailed and beautiful user interface, we believe PDF Converter Elite totally deserves this award.”

PDF Converter Elite 5 is out and about! Make sure you try it first!

It’s been more than one year since we released the version 4 of PDF Converter Elite. It had better conversion quality and OCR engine than PCE 3, but it had limited editing capabilities. With version 5 we tried to combine both, to keep and even more improve the conversion quality, to use the latest OCR technology, and on the other hand to restore some old editing features and introduce a totally new way of editing PDF documents. PDF Converter has just been released today and don’t wait too long to discover its new features:

Meet New PDF Editor on the Market

Apart from existing editing features, we added one quite distinguished PDF editing feature. From now on you can add or delete specific parts of the text directly on your PDF. If you need to apply just small changes to your PDF, to fix typos or rearrange pages, you don’t have to convert a PDF to editable file formats. With PDF Converter Elite your PDF behaves as an editable format.

edit pdf

Split PDF And Merge PDF Are Back

PCE 3 users probably remember these editing features. In PDF Converter Elite 5, you can extract pages from your PDF, merge whole PDF files or only specific pages of another PDF. In addition to that, you can merge selected pages after any page of the existing PDF, not just at the end.

Convert PDF to CSV – Default or Personalized Conversion

We know how much you like to use custom PDF to Excel conversion, so we added one more conversion type that has advanced custom options. Similar to Excel, in version 5 of PDF Converter Elite you can choose to convert PDF to CSV in two ways: with or without personalization of tables, columns and rows.

pdf to csv

Batch Conversion With Scanned PDF Files

Those users who convert multiple PDF documents to the same file format know how important is batch conversion- it saves time since all documents are converted at once. Batch conversion used to work with native PDF files only and now it works with scanned PDF files as well.

And that is not all! Download PDF Converter Elite 5 for free and take advantage of your 7-day trial period: http://www.pdfconverter.com/downloads/

 

How to Print to PDF

PDF files are used on occasions when you want to be sure that the end user will see the file the way you see it. Other file formats can alter the output because they are not compatible on every device. It also depends on MS Office version and operating system version. There are three ways to print to PDF and have your content preserved in the same formatting.

print to pdf

Print to PDF Online

If you don’t want to install anything on a computer and you prefer online tools, try Create PDF Online. With this online tool you can create a PDF in 3 simple steps. Upload the file, enter your email address and click Start. In a few minutes, you will get an email with the download link to your converted file. All converted files are deleted from the servers after 24 hours, due to privacy policy, so in that time you need to save a file on your computer.

 

Print to PDF Offline

If you don’t want to rely on internet and you don’t mind installing programs on your computer, try Free PDF Creator. It is a free tool for PDF creation and it creates a PDF from any Windows application. Open the file you want to print to PDF and click on File menu. Choose Print button and from the list of printers select Free PDF Creator. Click the Print button and then the Create PDF button to print to PDF.

 

Print to PDF on Mobile

 

If you like to use your mobile phone as a portable computer, download Save as PDF on your phone. Open the file you want to print to PDF and then tap on the Share button to access the Open in menu. There you will find the app and your file will be printed to PDF instantly.