Do you know you can insert a chart with a shortcuts key? You can use Alt + F1 to insert a chart. But here’s a twist. In Excel, default chart type is a two-dimensional column chart. So, if you want to insert a line chart or any other chart which you use frequently with a […]
Normally, when you need to select multiple cells which are not continuing, you press and hold the control key and then select each cell with the mouse.Right?That’s the simple method.But I can bet that you have never heard about selecting non-continues cells without using a mouse.The reason for this is no one ever found this […]
Steps For Adding A Secondary Axis In Your Chart Follow these simple steps to create a dual axis. Method 1 Select the data series for which you want to add a secondary axis. Right Click on it & Go to Format Data Series → Series Option → Activate Secondary Axis. Now, you have a two scales in your chart. […]
Developer tab in excel is one of the most important and highly useful options in excel. But, before you use it you need add it on ribbon.When you install Excel, you need to activate it for first time.So today in this post, you will learn 3 different methods to add developer tab in Excel for windows as well […]
If you have a cell with some specific font style, having a specific background color & you want to copy that formatting to some another cell, you can use format painter to do so.