Microsoft Excel

Excel doesn’t have a dedicated watermark option, we will share a few workarounds so you can watermark your worksheets.

4 Methods of inserting a watermark in a Microsoft Excel Sheet:

• Insert text using the Header option
• Insert an image using the Header option
• Insert text using WordArt
• Insert watermark using the Background option

Let us begin by looking at each of the methods in detail.

Read more

2 Methods of inserting a Date Picker in Microsoft Excel:

• Insert an object
• Insert a date picker add-in

Read more

When you create a chart in your Excel workbook, it’s created in the same sheet as your data by default. You might want to move the chart to a new sheet for reporting purposes. You can do this easily in MS Excel.

4 Methods of moving a chart to a new sheet in Microsoft Excel:

• Move chart to another Excel sheet
• Move chart to a new Chart sheet
• Move chart by copy-pasting
• Move chart using VBA code

Let us begin by looking at these methods in detail.

Read more

We can extract lots of information from a date field in MS Excel. The day of the week, the year of a transaction, are but two examples.

If, for example, you want to see the names of the days for transactions, you can convert the dates to text.

Keeping these things in mind, we’ve developed this tutorial to help you convert dates to text in MS Excel. Using these methods, you can convert dates to a wide range of texts that suit your requirements.

2 Methods to convert date to text in Microsoft Excel:

• Use the TEXT function
• Use the Text to Columns feature

Let’s begin by having a look at these methods.

Read more

When doing calculations or writing chemical formulas, you may need to insert a subscript in your Excel spreadsheet. 

Don’t know how to do it? You don’t have to worry as there are several methods to do that. Here are 8 methods that you can use to insert a subscript in your Excel workbook. 

8 Methods of inserting a subscript in Microsoft Excel:

• Use the Font tab in Format Cells
• Use keyboard shortcuts
• Use the Subscript option
• Use the Equation option
• Use the Ink Equation option
• Use third-party websites
• Use the Custom option in the Number tab

Let us begin by looking at how each of these methods works.

Read more

Excel has many useful features like Macros, VBAs, and Add-ins. You can access these features via the Developer tab. However, the Developer tab is not visible by default. If you use these features often, you can add the Developer tab to your ribbon for quick access.

2 Methods of adding the Developer tab in Microsoft Excel:

• Add the Developer tab via the menu ribbon
• Add the Developer tab via general Options

Let us begin by looking at these methods in detail.

---

Read more

While working in an Excel workbook, you may want to add extensive information to it. However, it’s easier to embed or link information. For example, you may want to insert a Word document or a PDF in your MS Excel workbook. For this, you can use the Object feature in Excel. By inserting an Object in MS Excel, you can embed an external object into the worksheet.

2 Methods of inserting an object in Microsoft Excel:

• Insert an object by creating a new file
• Insert an object by uploading an existing file

Let us begin.

---

Read more

4 Methods to add months to a date in Google Sheets:

• Use the DATE function when the number of months to be added is the same.
• Use the EDATE function when the number of months to be added are different.
• Use the End of Month function.
• Use a generic formula (handy only in particular cases).

Let us begin.

Read more

When writing chemical formulas or calculations, you may need to insert a superscript in your Excel spreadsheet.

Not sure how to do it? Don’t worry as there are several methods to insert a superscript. Here are 10 methods that you can use in your Excel workbook. 

10 Methods of inserting a superscript in Microsoft Excel:

• Use the Font tab in Format Cells
• Use keyboard shortcuts
• Use the Superscript option
• Use the Equation option
• Use the Ink Equation option
• Use the Alt key
• Use the CHAR function
• Use the Custom option in the Number tab
• Use third-party websites
• Use Microsoft VBA code

Let us begin by looking at how each of these methods works.

Read more

When you type in a large decimal number, MS Excel will likely round off the number. This can be due to several reasons: 

• The column width is too small
• The format is set to General instead of Number. 
• The number of decimal places to be displayed is set for a lower number.

As a result, it can be annoying when Excel automatically rounds off your numbers. However, you can easily rectify this by using any of the methods given below.

5 Methods to stop Microsoft Excel from rounding numbers:

• Increase the column width
• Increase the decimals
• Format the cells
• Add an apostrophe
• Format the number as text

Let us begin by looking at all the methods in detail.

---

Read more