Excel - Hide and Unhide Rows and Columns and Split Panes
We frequently print Excel data as a hard copy or email data as a PDF. Some data may be confidential or sensitive, and other users do not need to see it. This is when hiding columns and rows comes in handy. Hidden columns and rows do not show when printed. Another feature of Excel is Split Panes is handy when you need to see data that are nowhere near each other. Maybe you want to view your records compared to other records. When you split, you get two scroll bars.
0:00 Intro
0:35 Data layout
1:05 Hide columns
1:45 Unhide all at one time
2:15 Find hidden rows or columns
2:55 Split columns
4:02 Split rows
Popular Videos from Chris Menard
Add polling to Zoom Meetings
• Add polling to Zoom Meetings by Chris...
Create a PivotTable in Excel using multiple worksheets
• Create a PivotTable in Excel using mu...
What-If analysis in Excel with a Data Table
• What-If analysis in Excel with a Data...
Insert a Word Document into a PowerPoint presentation
• Insert a Word Document into a PowerPo...
Excel - Conditional Formatting find duplicates on two worksheets
• Excel - Conditional Formatting find d...
Microsoft Word - delete the empty or blank page at the end of your document
• Microsoft Word - delete the empty or ...
Sum up hours and minutes in Excel by Chris Menard
• Sum up hours and minutes in Excel by ...
OneDrive - Sync Icons Explained for files and folders
• OneDrive - Sync Icons Explained for f...
Break-even analysis in Excel with a chart / cost-volume-profit analysis by Chris Menard
• Break-even analysis in Excel with a c...
#chrismenardtraining #exceltraining #msexcel #chrismenard
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
Watch video Excel - Hide and Unhide Rows and Columns and Split Panes online without registration, duration hours minute second in high quality. This video was added by user Chris Menard 26 May 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 6,778 once and liked it 61 people.