Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Microsoft Technologies Articles
Page 125 of 175
How to add background color to headers or footers in an Excel sheet while printing
We know that we can add pictures or contents to the header or footer in an Excel workbook, which will be displayed while printing. Here you can also add color to the background of headers or footers. There is no built-in function available to do it. But I can show you some ways to achieve this. Add background color to header or footer by fill color Below are the steps that you need to follow to achieve this. Step 1 Open an Excel workbook, click on Page Layout and then click on Page Setup as shown in the below screenshot. ...
Read MoreHow to add a single data point in an Excel line chart?
Excel makes it simple to combine two data series into a single chart. Now, only one data point must be added to an existing Excel line chart. Add a single data point in an excel line chart Let’s understand step by step with an example. Step 1 In the first, we must create a sample data for chart in an excel sheet in columnar format as shown in the below screenshot. Step 2 Then, select the cells in the A2:B8 range. Click on Insert tool bar and select chart>Line>2-D Line to display the Line graph. Below is the screenshot ...
Read MoreHow to add and change document author (document properties) in Excel
In the Excel workbook by default author will be the name of the person who creates the Excel workbook and it usually is the one name. At times workbook may be created by multiple/several persons, in that case, it requires adding the author names to the Excel workbook. Here you will see how to add and change the author names in an Excel workbook. How to quickly add authors for Excel workbook Below steps guides you, on how to add the other authors to the current Excel workbook. Step 1 Open an Excel workbook, click on File and then select ...
Read MoreHow to add arrows to line / column chart in Excel
If your worksheet has a column chart or a line chart, you may find that you need to add arrows to the column chart in order to show how the values are related to one another in terms of increasing or decreasing. In point of fact, there is not a direct method for adding the arrows to the column bar; nevertheless, you can draw the arrow shapes and copy them to the column chart. In this article, I'll discuss the process of adding arrows to a line or column chart. Add arrows to column chart in excel Step 1 In ...
Read MoreA VBA code to list all add-ins in Excel
Microsoft Excel can receive additional commands and capabilities through the use of add-ins. Because Excel does not make its add-ins immediately accessible by default, you will need to first install and then (in certain situations) activate the add-ins in question before you can make use of them. A group of AddIn objects that collectively represents all of the add-ins that can be used with Microsoft Excel, regardless of whether or not the add-ins have been installed. We can list all add-ins in an Excel sheet through a VBA code. So let’s see the VBA code and how it works ...
Read MoreAdd currency symbols in Excel
Excel provides a variety of options for users who wish to insert symbols into their work. Utilizing the keyboard and the buttons on the Ribbon, creating a formula, and formatting cells are some examples of these. Due to the fact that different currencies have different values, it is often absolutely necessary to label values with their respective currencies. In this tutorial, we are going to learn about different methods to add currency symbols in excel. Using Format Cells You will need to format the numbers so that they are compatible with currency if you wish to display them as monetary ...
Read MoreAdd text and number into specified position of cell in Excel
There may be times when you need to insert the identical text into all of the cells that are contained inside a column. It's possible that a specific title needs to go before the names in a list, or that a specific symbol needs to go at the end of the text in each cell. Both of these things need to be done. The task of adding text or numbers to cells in Excel is one of the most often performed tasks. Including things like inserting spaces between names, including prefixes and suffixes in cells, and inserting dashes in social ...
Read MoreChange chart colour based on the value in Excel
Conditional formatting refers to the process by which you can show distinct value ranges as different colours in a chart. This may be something you wish to do when you insert a chart at times. Because the Excel feature only applies to cells and not charts, we can apply the concept of conditional formatting to column charts by combining different data series. This is because conditional formatting is only applicable to cells. For instance, if the value range is 0–150, the series colour should be shown as blue. If the value range is 151–250, the colour should be shown ...
Read MoreChange the font / size of row and column headings in Excel
When you use the Excel workbook, have you ever tried to alternate the font or measurement of row and column headings to make the headings larger or extra beautiful? In fact, Excel offers some tricks for you to solve this task. With the futures we have in the Excel workbook, you can change the font and size of the row and column as you like. Change the Font and Size of Row and Column using the Styles Feature in Excel Following are the steps to change the Font/Size and row/column in excel. Step 1 Open the workbook that you want ...
Read MoreCombine the COUNTIF and LEFT functions to count cells that begin with a certain character in Excel
Excel's COUNTIF function is used to determine the number of cells inside a given range that fulfil the requirements of a certain condition. In the criteria, logical operators such as ">,
Read More