Saturday, November 23

Tag: Menu bar in excel

Dec112020 by excelhelp13No Comments
Goto Special In Excel

Goto Special In Excel

Home Menu, Menu Bar
DEFINITION:- The Go To Special Function In Excel Allows You To Quickly Select All Cells That Meet Certain Criteria, Such As Cells Containing: Comments, Constants, Formulas (Numbers, Text, Logical, Errors), Blank Cells, Objects Etc. Blank Will Select The Blank Cell Only.Current Region Will Select From The Active Cell To Last Row. makes Sure You Don't Have A Blank Cell Otherwise It Will Consider Above The Blank Row As Last Row.Current Array Will Select The Active Range Belongs To.Object Will Select Any Object Available In A Range. Ex:- ShapesLast Cell Will Select The Last Used Cell In A Worksheet. Even If You Delete The Data From Cell.Visible Cells Will Select Only Visible Cell If Any Filter Is Applied Or Even Any Row Or Columns Are Available.Conditional Formatting Will Select The Forma...
Read More
Dec102020 by excelhelp13No Comments
ScreenShot In Excel

ScreenShot In Excel

Insert Menu, Menu Bar
Definition:- Using The Screenshot Option You Can Quickly And Easily Add A Screenshot To Your Worksheet To Enhance Readability Or Capture Information Without Leaving The Program That You Are Working In. This Feature Is Available In Excel Above Version Of 2007. Steps:- Insert Tab > Screenshot.Choose Window Thumbnail In Available Windows Or Use Screen Clipping.Format And Crop Your Screenshot In Excel.You Can Also Take The Quick Snap Shot Of Other Open Application And Quick Add To Your Worksheets.
Read More