Excel Ustaad

01/08/2022

How to Create Multiple Slicers in Excel? Urdu and Hindi Video tutorial

11/06/2022

Change slicer style

08/04/2022

How to Lock the Position of a Slicer in Excel Don't Move or Size with Cells Slicer Setting?
https://youtu.be/T8k7luU6Fxg

08/04/2022

How to Lock the Position of a Slicer in Excel Don't Move or Size with Cells Slicer Setting?
How to Lock the Position of a Slicer in Excel?
Lock the Position of a Slicer in an Excel Worksheet So It Can't Be Moved
Slicers are a great tool in Excel to filter tables or pivot tables. You can lock the position of a slicer in an Excel worksheet using a two-step process. First, select the slicer or slicers and Disable resizing and moving in the Format Slicer task pane (and choose other options based on your preferences). Second, protect the sheet using the Review tab in the Ribbon. There are a few important options you'll need to select to get this to work.
To lock the position of one or more slicers in the Format Slicer task pane:

Right-click the slicer. If you are changing multiple slicers, Ctrl-click each slicer and right-click one of the selected slicers. A drop-down menu appears.
Select Size and Properties in the menu. A task pane appears.
In the Format Slicer task pane, click the arrow beside Position and Layout to expand it.
Check or select Disable resizing and moving.
In the task pane, click the arrow beside Properties to expand it.
Select Don't move or size with cells.
Uncheck or de-select Locked. If you leave this checked, you won't be able to use the slicer(s).
Watch this video for live doing Format Slicer task pane
To protect the sheet and allow filtering with the slicer(s):

Click the Review tab in the Ribbon.
Select Protect Sheet in the Protect group. A dialog box appears.
If required, enter a password (be sure to keep track of your passwords).
Select or check Select locked cells (this should be selected by default).
Select or check Select unlocked cells (this should be selected by default).
Select or check Use PivotTable and Pivot Chart and Use AutoFilter (you will need to scroll down in the dialog box).
Click OK.
If prompted, re-enter the password and click OK.
You must select Use Pivot Table and Pivot Chart and Use AutoFilter in the Protect Sheet dialog box
how to protect cells in excel without protecting sheet?,
how to show slicer horizontally in excel?,
how to resize a slicer in excel?,
excel lock slicer selection,
how to lock a cell in excel formula?,
excel slicer disable resizing and moving,
how to use slicers to filter data in excel?,
excel slicer formatting,

28/03/2022

How to Lock the Position of a Slicer in Excel Don't Move or Size with Cells Slicer Setting
https://youtu.be/7qp0JTjOerY
Do you want to make impressive looking and functioning Excel workbooks without too much effort?
Of course you do!
If you want to create interactive dashboards in Excel and visually explore your data, then you need to start using slicers and timelines.
They’ll really take your workbooks to the next level… and they’re easy!
In this post, we’re going to learn everything there is to know about slicers and timelines in Microsoft Excel.
There’s a lot to cover, so let’s get started
What Is A Slicer In Excel?
A slicer is an object in Excel that allows you to filter your data.
It displays all the possible values from a selected column of your data and each value will display as an individual button inside the slicer. The buttons can be used to toggle the active filtering of your data set.
The slicer object floats above the spreadsheet grid and will always be visible and available to use.
Slicers can be used with both Tables and PivotTables.

how to lock a pivot table but allow refresh,
how to show slicer horizontally in excel,
excel lock slicer selection,
how to lock pivot table format,
protect pivot table but allow filter,
cannot edit pivot table on protected sheet slicer,
excel prevent slicer delete,

16/03/2022

Turn Off Autofit Column Widths on Update | Disable autofit column widths for Pivot table in Excel
https://youtu.be/fiY_STs6ues

14/03/2022

Create Excel Dashboard in 03 Mints Live Practical Mast Class in Urdu and Hindi
https://youtu.be/65FudCRwEHs

13/03/2022

13/03/2022

Create Excel Dashboard in 03 Mints Live Practical Mast Class in Urdu and Hindi

12/03/2022

How to use Slicers in Excel (In Easy Steps)
https://youtu.be/-WKRt_JSbxA

12/03/2022

12/03/2022

11/03/2022

How to Insert Slicer in Excel ? Live Practical Video Tutorial Urdu and Hindi Short Video
Slicers provide buttons that you can click to filter tables, or PivotTables. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is currently displayed.
How to use Slicers in Excel (In Easy Steps),
how to insert slicer in excel without pivot table,
how to add slicer in excel,
how to insert slicer in excel mac,
how to use slicers to filter data in excel,
slicer in excel ,
excel slicer dashboard,
excel slicer no connections found,

04/03/2022

How to Remove Excel Gird Line? Show or hide gridlines on a worksheet Live Practical Video Tutorial
Gridlines in Excel are those faint gray lines that you see around the cells in the worksheet. These gridlines make it easier to differentiate between the cells and read the data.
Now don’t confuse gridlines with borders. Gridlines are visible on the entire worksheet while borders can be applied to the entire worksheet or to a selected region in the worksheet.
You can change border settings such as color, width, style, etc., but in the case of gridlines, you get limited options to change the look of the gridlines.
https://youtu.be/_Js-WfJ1bp8
remove gridlines excel shortcut,
how to remove lines in excel for specific cells,
gridlines in excel,
how to add gridlines in excel,
gridlines disappear in excel,
how to add gridlines in excel for specific cells,
how to remove gridlines in excel when printing,
how to remove gridlines in excel mac,

04/03/2022

How to Remove Excel Gird Line? Show or hide gridlines on a worksheet Live Practical Video Tutorial
Gridlines in Excel are those faint gray lines that you see around the cells in the worksheet. These gridlines make it easier to differentiate between the cells and read the data.
Now don’t confuse gridlines with borders. Gridlines are visible on the entire worksheet while borders can be applied to the entire worksheet or to a selected region in the worksheet.
You can change border settings such as color, width, style, etc., but in the case of gridlines, you get limited options to change the look of the gridlines.

remove gridlines excel shortcut,
how to remove lines in excel for specific cells,
gridlines in excel,
how to add gridlines in excel,
gridlines disappear in excel,
how to add gridlines in excel for specific cells,
how to remove gridlines in excel when printing,
how to remove gridlines in excel mac,

What are Gridlines in Excel?
Gridlines in Excel are the horizontal and vertical gray lines that differentiate between cells in a worksheet. The gridlines guide users to differentiate between the specific cells and read the data in an organized manner. They also help users navigate through the worksheet columns and rows with ease.

Without gridlines, users would face difficulties reading the data due to the lack of organization. Also, most users confuse gridlines with cell borders, which are applied to specific regions of the worksheet. Unlike borders, gridlines are visible on the entire worksheet and cannot be applied to a specific region of the worksheet compared to the borders. Also, when printing a worksheet, the gridlines are not printed on the paper, whereas any borders applied to the worksheet appear on printed worksheets.



Understanding Excel Gridlines
Gridlines in Excel apply, by default, in the whole worksheet or workbook, and cannot be applied to a specific section of the worksheet. If you want to make a certain section of the worksheet different from the rest, use border lines to make customizations to specific cells or group of cells.

Gridlines are displayed in a workbook using a grey color that is applied automatically. If you want o change the gridline colors, Go to the File tab, Options, Advanced and then click Grid Color. Select the color you want to use and then go back to the worksheet.

28/02/2022

28/02/2022

Do You Want to Watch Short Clips | Get Your Answer for Excel Question Via Excel Short Video’s?
https://www.youtube.com/watch?v=0Vca7qIQjnE

28/02/2022

Do You Want to Watch Short Clips | Get Your Answer for Excel Question Via Excel Short Video’s?

27/02/2022

https://www.youtube.com/watch?v=GSR4-IdO8QI

25/02/2022

Learn Free Excel in Short Video | How to Change Number Format in Pivot Table?
In the pivot table, right-click on a cell in the value field. ...
In the popup menu, click Value Field Settings, and then click the Number Format button.
In the Format Cells dialog box, select the formatting that you want.

25/02/2022

Learn Excel in Short Video How to Create Pivot Table in Excel

17/12/2021

How to Open Excel in Short Cut? Excel ShortCut

Run Box
Press “Windows-R” to open the Run box in Windows 8.
Type “excel.exe” into the Run input box. ...
Type a space, and then type “/” followed by the first switch. ...
Type a space, and then type “/” followed by the second switch. ...
Click “OK” or press the “Enter” key to execute the command.

13/09/2021

Part #03 Print and Setting Microsoft Excel 2019 Full Free Course in Urdu and Hindi
https://youtu.be/HqgLpSdqR1M

22/07/2021

Part #01 Introduction and interface Microsoft Excel 2019 Full Free Course in Urdu and Hindi
https://www.youtube.com/watch?v=SkQTN-68EHw
Part #02 Open Save NEW and Save As Microsoft Excel 2019 Full Free Course in Urdu and Hindi
https://youtu.be/IAHqoxzPwfs
Fully Excel Playlist Link :- https://www.youtube.com/watch?v=SkQTN-68EHw&list=PLICQlAU1HL9Z_Ci_kPrfIhARZZM_1Y86v
Subscriber our channel for more updates :- https://www.youtube.com/channel/UCbdjog-cT8N5-poaDtV5jJw?sub_confirmation=1

05/06/2021

Get Excel KPI Dashboard Order Now Link in Description
Link:- https://www.fiverr.com/sarwar_ahmad/create-any-type-of-excel-kpi-dashboard
https://youtu.be/0Uz9Hy3VQSk
I will Do anything you need in Excel | Get Excel KPI Dashboard in 50 USD
https://youtu.be/7L3atWQnqbM
https://www.fiverr.com/sarwar_ahmad/create-any-type-of-excel-kpi-dashboard
Excel recommends charts on the “Insert” tab of the ribbon at the top of Excel. Take your chart and copy and paste it into a separate worksheet. You can do this for each of the charts you're building for your KPI dashboard in Excel. The new sheet where you place these charts will become your dashboard.
KPI Management Reporting Templates for Excel Users. Start Right Now. Instant Download. View Services. View Blog. Multiple Payment Options.
Pick Your Data Visualization Freelancer On Fiverr. Get It Done Today! Connect To Top Talent In Minutes And Start Turning Ideas Into Realities
A Key Performance Indicators (KPI) dashboard is one of the most used dashboards in business.
Its primary objective is to show the performance of key KPIs and provide a comparative view of other KPIs or companies.
Watch Full Excel Video Course in Urdu and Hindi
https://www.youtube.com/watch?v=J1plOGM6Orw&list=PLYsHOUqDNFnuGCkAtwWf4iLeY0KWkzEL3