Pradeep Kumar has Published 1236 Articles

How to hide or show chart axis in Excel?

Pradeep Kumar

Pradeep Kumar

Updated on 10-Sep-2022 08:17:34

2K+ Views

What is an Axis? An Axis on a chart in excel or google sheets is a horizontal or vertical line containing units of measure. The axes border the plot vicinity of column charts, bar graphs, line graphs, and different charts. An axis shows devices of measure and offers a body ... Read More

How to grey out cells based on another column or drop down list choice in excel?

Pradeep Kumar

Pradeep Kumar

Updated on 10-Sep-2022 08:17:10

7K+ Views

Excel's Conditional Formatting is a feature that is both one of the simplest straightforward and one of the most powerful features. When you want to highlight cells in Excel that meet a certain criterion, you can utilize a feature in Excel called conditional formatting, which gives the functionality as its ... Read More

How to list all dates between two dates in Excel?

Pradeep Kumar

Pradeep Kumar

Updated on 10-Sep-2022 08:16:32

4K+ Views

Imagine you are in a scenario where you need to construct a table that is organized by date. For instance, you are making a schedule and need to specify a list of activities arranged by date in the appropriate order. You would require a list of dates in the event ... Read More

How to quickly check if a file (workbook) is open or closed in Excel

Pradeep Kumar

Pradeep Kumar

Updated on 10-Sep-2022 08:16:03

721 Views

If you operate on a team, there will inevitably be situations in which many people attempt to use the same file. It is possible that when your team member is reviewing certain information in a workbook at the same time as you are attempting to rename the file on your ... Read More

How to quickly insert a line based on current date in Excel

Pradeep Kumar

Pradeep Kumar

Updated on 10-Sep-2022 08:15:07

4K+ Views

You have a sheet that already has a row with dates, and you want to add a line that will automatically update to reflect the current date each time the workbook is opened. This line should be inserted directly to the right of the row holding the dates. Insert a ... Read More

How to quickly jump to the cell with current date in Excel

Pradeep Kumar

Pradeep Kumar

Updated on 10-Sep-2022 08:14:30

3K+ Views

If you want to bounce to a particular cell or current date in Excel, you can apply go to Name box which is left to the formula bar, and type the cell reference which you want to jump to and then press Enter key. You can follow the Find and ... Read More

How to repeat a sequence of numbers in Excel?

Pradeep Kumar

Pradeep Kumar

Updated on 10-Sep-2022 08:14:05

14K+ Views

When dealing with a large dataset in Microsoft Excel, it is occasionally necessary to repeat the number pattern. The information of a number of different employees is included in today's dataset. Utilizing Excel's keyboard shortcuts, the Fill command, and the IF, MOD, and ROW functions, amongst others, enables us to ... Read More

How to zoom all tabs in one size in Excel?

Pradeep Kumar

Pradeep Kumar

Updated on 10-Sep-2022 08:13:36

3K+ Views

It is handy to have the ability to make a worksheet appear larger on the screen of the computer, especially if the display of the computer is on the smaller side. You might also need to zoom out to get a better view of the worksheet in its entirety. ... Read More

Simple ways to insert delta symbol in Excel

Pradeep Kumar

Pradeep Kumar

Updated on 10-Sep-2022 08:13:03

291 Views

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. The Delta symbol is an example of a symbol that is frequently utilized in ... Read More

Simple ways to insert star symbol in Excel

Pradeep Kumar

Pradeep Kumar

Updated on 10-Sep-2022 08:12:39

11K+ Views

The majority of spreadsheets contain a lot of numbers. There are several of them that have text. But you may also insert symbols and special characters in your spreadsheet if you want to personalize the information that is contained there and open up some interesting new possibilities. Excel treats them ... Read More

Advertisements