Home Menu:-
Cute:- To transfer high lighted cell value at new cell
position.
Copy:- To make duplicate of the cell value.
Paste:- To display the cuted or copied cell values at new
cell position.
Format:- To
paste only format of the copied cell.
No Border:- Paste
only value of the copied cell without borders.
Transpose:- Paste vertically copied values as horizontally.
Paste as link:- Paste
with link of the copied cell if it changes this will automatically changed.
Paste as hyper
link:- Paste external link of the
excel file at here.
As Picture:- Paste
the value as picture not the value or data.
Format Painter:- Set same format to next selected
cell.
Font:- Set the font face style of the cell data.
Bold (B):- Set
cell data Bold.
Italic(I):- Set
cell data as Italic.
Under Line(U):- Set
the cell data as under lined.
Double underline:- Set the cell data double underlined.
Size:- Fix the cell data size in the work book.
Increase font:- Increase Continuously size of the cell data.
Decrease Font:- Decrease Continuously size of the
fonts inserted in cell.
Clear Formatting:- Remove given format from the text of
the cell.
Fill color:- To
fill colors in the current cell.
All Borders:- To
set borders around the cell.
Font Color:- Change
the text color inserted in cell.
Top align:- Set
Text of the cell at top of the cell area.
Middle Align:- Set
text of the cell at middle of the cell area.
Bottom Align:- Set
data at the bottom of the cell area.
Align text left:- Set
data of cell at left side of cell area.
Align text right:- Set data of the cell at right
side of the cell area.
Align Center:- Set
data of the cell at center of the cell area.
Decrease Indent:- Remove left blank spaces from the
cell area.
Increase Indent:- Increase the left side blank spaces
in the cell area.
Wrap text:- Set long entered data
in that cell by wrap it into multiply lines.
Merge and center:- To merge high lighted cells into one
cell and set there data at center of the cell.
Number Format:- To Set
the format of the cell as decimal numbers.
Account Number:- To set
the cell format as accounting number format.
Percent Style:- To
Set the cell value as percent style data.
Comma Style:- To
Set the cell value as comma style digits separated by commas.
Increase Decimal:- To
Increase step by step decimal places in the given digit in cell.
Decrease Decimal:- To
decrease step by step decimal places from the given digits.
Conditional formatting:- Set
the condition of the selected rank of the cells.
High light cell rules:- To
set rules for selected cell range.
Greater Than:- If
the value is greater than give condition show the different color in selected
range of cells.
Less Than:- If
the value is less than give condition show the different color in selected range
of cells.
Between:- If
the value is between give condition show the different color in selected range
of cells.
Text that contain:- If
the cell contain given text change the color of the selected range.
A Date accruing:- If
the cell contain the date you mentioned than change the color or selected
range.
Duplicate values:- If
the values are duplicate in the given range change the color of that range.
Top 10 items:- To
show the different color of cells from the list which are top 10 valued.
Top 10 %:- Show
the top ten percentage cells from the list of cells.
Bottom 10 items:- Show
the bottom ten valued cells from the list.
Bottom 10%:- Show
the bottom ten percentage valued cells from the list.
Above Average:- Show
the above averaged cells from the list of cells.
Bellow Average:- Show
the bellow averaged cells from the list of sells.
More rules:- Set
more rules about your selection.
Data Bars:- Show
the rules in data bars.
Color Scale:- Show
the rules in colored scales.
Icon Sets:- Show
the given rules in icons style sets at cells.
Clear Rules:- To
remove the given rules from the list.
Manage rules:- Design
new rules by your self.
Format as table:- Design
the data list as the tables.
Insert Cell:- To
insert a cell between the give data.
Insert sheet row:- To
insert a blank row between the given list of values.
Insert sheet column:- To
insert a blank column between the given list of values.
Delete cell:- To
remove the cell from the given list of
values.
Delete sheet row:- To
remove the row from the given list of values.
Delete sheet column:- To remove
the column from given list of values.
Format :- To
set the format of the cell.
Row Height:- Show
the height of the current rows.
Auto fit row height:- To fit
the height of the row as the contents width is long.
Column Width:- To
set the current column width.
Auto fit column width:- To set automatically width of the column as the data long in it.
Default width:- Show
the default width of the columns.
Hide and un hide:- Hide
or show the rows and columns.
Organize sheet:- To
set the sheet options.
Rename Sheet:- To
change the name of the current sheet.
Move or copy sheet:- To move
the sheet at end of other sheets or create a duplicate copy of the current
sheet.
Tab Colors:- Set
the colors of the tab.
Protection:- Set
the code on the data.
Protect sheet:- Set
the code on the sheet.
Lock cell:- To
lock the current sheet cell.
Format cell:- change
the cell format as you need.
Auto sum:- Automatically add all above or left rang of the values.
Sum:- To
add the given range of the cell data.
Average:- To
calculate the average of given range of the data.
Count numbers:- To
count the number of the cells which have the data.
Max:- To
pick up the maximum number from the list of the data.
Min:- To
pick up the minimum number from the list of the data.
More Functions:- To
show the more functions about values.
Fill:- To
fill the same number in the selected range of the cells.
Down:- To
fill same number in down selected cells.
Left:- To
fill same number in left selected cells.
Right:- To
fill same number in right selected cells.
Up:- To
fill same number in up selected cells.
Across work sheet:- Set
data across the worksheet.
Series:- Set
the series of numbers natural, even or odd or specify by user.
Justify:- To adjust the data in the cell.
Clear:- Remove
content from the sheet.
Clear all:- Remove
all contents and format etc.
Clear content:- Remove only contents not the format nor any thing in cell.
Clear comment:- Remove
only comment from the specific cell.
Clear hyper link:- Remove
hyperlink from the current cell.
Sort A to Z: Set
the series of the data a to z or lowest to highest or reverse.
Costume sort:- Set
the series of the data specify condition by user.
Filter:- Set
filter on the data for easy to watch them with conditions.
Clear filter:- Remove
the given filter from the data.
Find:- Search
the specify data from the range of the data.
Replace:- To
change the finded data with an other data.
Go to:- To
jump on particular place or or cell address.
Goto formula:- Jump
on formula given cell.
Goto Comment:- Jump
on comments.
Goto constant:- Jump
on the constants.
Goto data validations:- Jump on
the valid condition given data cells.
Select object:- Highlight
given object.
Selection pane:- Open
the selection pane window have entered objects names in the sheet.
No comments:
Post a Comment