2 Ways to Color Alternate Rows in Google Sheets
- Using the built-in function of Google Sheets
- Using a formula in the conditional formatting
How to color alternate rows in Google Sheets
Team OfficeBeginner
How to Find and Replace text in MS Word
Now, there are about two ways you can find and replace text in MS Word:
Two Ways to Find And Replace Text in MS Word
- Using the View Tab in the Ribbon
- Using the Shortcut Key
Both of these methods will be covered in this guide down below. We also made sure to include a few intermediate procedures to better filter your search results.
How to Insert a Text Box in MS Word
Adding text boxes can make your document stand out.
Two Ways to Insert a text box in MS Word
- Using the pre-defined text box in MS Word
- Using the Draw Text Box tool in MS Word
How to wrap text around table in a google doc
Text wrapping is a way of positioning the text in your document. When you wrap text around an object, you surround it with text. Some examples of objects that you can wrap text around are images, charts and tables.
Google Docs allows you to wrap text around some objects, like images. However, it doesn’t have the option of wrapping text around a table.
Hence, you cannot directly wrap text around a table in Google Docs. However, there are some alternative methods you can use. In this article, we will be talking about five of these methods.
5 ways to wrap text around table in google docs
- Using Google Sheets
- Converting a table into an image
- Creating a table in the Drawing window using text boxes and shapes
- Creating a table within a table
- Using a column of a table for text
Also, this article is intended for beginners. So, you can follow along even if you have never used Google Docs before.
Before we talk about the methods, let’s understand what text wrapping is.
What is text wrapping?
In Google Docs, there are 3 ways you can position text around an object. The first is ‘In line,’ which is the default mode in which text is placed around an object. This means that the object is placed on the same line as the text. Here’s what the ‘In line’ format looks like:
The other option is the ‘Break text’ option. As the name suggests, this option places the object on a separate line from the text. This is what the ‘Break text’ option looks like:
Lastly, we have the ‘Wrap text’ option. As we mentioned, this option places the text around the image. This is what the ‘Wrap text’ option looks like:
There are many benefits of the text wrapping feature. Firstly, it uses space more efficiently than the in-line and break text formats. Hence, if you want to print your document, you would need fewer pages. This saves you paper.
Another benefit is that it improves your document’s readability. With the in-line and break text options, the object separates the text. This may distract you from the text. However, with the wrap text option, the text is continuous.
How to setup custom page size in Google Docs
The page size of a document refers to its length and width.
In Google Docs, the default page size (or paper size) is the ‘Letter’ format. In this format, the width of the document is 8.5 inches and its length is 11 inches.
Google Docs allows you to change the default page size. You can choose from one of the many options for page size formats. Some examples are tabloid, legal, A3 and A4.
However, Google Docs doesn’t allow you to customise your page size. This means that you have to use one of the existing formats for page sizes. You cannot create your own format.
There are methods we can use to overcome this limitation. In this article, we will be talking about three of these methods.
3 ways to setup custom page size in Google Docs
- Look at the available page sizes and choose one that is similar to the one you want
- Use add-ons like Page Sizer
- Use ‘Print’ to change the page size of the document (you can save it as well)
Note that this article is written for complete beginners. Hence, even if you’ve never used Google Docs before or are not familiar with it, you can follow along.
With that introduction, let’s start.
How to Alphabetize a list in MS Word
You may have a list of items in your Word document that you want to sort or alphabetize in a certain order. You may have numbered or bulleted your list, it does not matter. Word treats any item in the list as separate paragraphs. It allows sorting the list in either ascending or descending order. But Word cannot handle multi-level lists and may mix up the levels after sorting.
Depending on the content in your list, you can:
- Alphabetize from A to Z or Z to A (ascending or descending).
- Organize numerically in ascending or descending order.
- Organize dates in ascending or descending order.
- Sort by fields and headers
- Sort in three ways
Word allows you to alphabetize a list that has:
- Single Words
- Many Words
- Text in a Table
We will show you how to handle all the methods. Let us begin.
How to Create Split Cells in Google Sheets
Knowing how to create split cells in Google Sheets can save you a lot of time when compiling data. This can be for names, addresses, personal information, and so on. You can even use this for storing items in your shop, as long as you have a proper format.
Now, there are two ways to split your cells.
2 Ways to Create Split Cells in Google Sheets
- Using the SPLIT function
- Using the Split text to columns feature
Both these methods have varying effects, but with the same outcome. We’ll explain in detail what we mean by that later on. Throughout this article, we’ll go over examples, the pros and cons of both methods, and when you should split cells in Google Sheets. If you aren’t familiar with Google Sheets at all, you have nothing to worry about!
The steps below are made with beginners in mind, so you should be able to just follow through the tutorial. Without further ado, here’s how you can create split cells in Google Sheets.
Let’s dive right in!
How to Wrap Text in Google Sheets
Learning how to wrap text in Google Sheets is a fantastic skill that helps you take your spreadsheets to the next level. It’s one of those underrated skills that show just how particular you are with the details in your presentation. Being able to clearly see your text, information, or any data on your spreadsheet is a massive plus to productivity.
With that said, there are a couple of ways that you can go about wrapping text in Google Sheets.
3 Ways to Wrap Text in Google Sheets
- Wrap text through format tab
- Wrapping text through the toolbar
- Manually wrapping your text
Each method has its perks, especially the third one where you can manually wrap your own text. With that said, we’ll cover all of this later on in a step-by-step guide. We’ll also provide examples and sample spreadsheets that you can download so you can try this out for yourself.
With that said, don’t be intimidated to follow this article if you’re new to Google Sheets. These steps are beginner-friendly and should be easy for you to go over.
Let’s get started!
How to Create a Dropdown List in Google Sheets
2 Ways to Create a Dropdown List in Google Sheets
- Create dropdown list using a range of cells
- Create dropdown list by manually specifying
How to move images in Google Docs (S)
Once you’ve uploaded your images to Google Docs, you can move them in the document by following a few simple steps. In this article, we will talk about the different methods for moving images. We will also provide the steps for each of them.
Specifically, we will be talking about these four methods of moving images in your Google Doc:
- Using your mouse pointer to drag the images in the document
- Using one of the position options (either move with the text or fix the position on the page)
- Using one of the alignment options (left, centre, and right)
- Copying/cutting and pasting the images
Note that this article is intended for complete beginners. Hence, you can follow along even if you’ve never used Google Docs before. This is why we will also be talking about how to upload images to a Google Docs document (and other image settings).
With that introduction, let’s start.