Transcription of Microsoft Excel: Advanced - Towson University
{{id}} {{{paragraph}}}
Microsoft excel : Advanced Participant Guide OTS Publication: ex1602 08/02/19 2019 Towson University . This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivs License. Details available at Table of Contents Text to Columns .. 4 Concatenate .. 5 The Concatenate Function .. 5 The Right Function with Concatenation .. 5 Absolute Cell References .. 6 Data Validation .. 7 Time and Date Calculations .. 9 Conditional Formatting .. 10 Exploring Styles and Clearing Formatting .. 10 Using Conditional Formatting to Hide Cells .. 11 The IF Function .. 12 Changing the Value if false Condition to Text .. 12 3D Formulas .. 13 Pivot Tables.
Microsoft Excel Advanced: Participant Guide 11 Using Conditional Formatting to Hide Cells If you have cell contents and you do not want to be visible, you can use conditional formatting to hide them. 1. In the Conditional Formatting spreadsheet, select cells G4 through G13. 2. From the Conditional Formatting dropdown menu, select New Rule.
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}