Keyboard shortcuts | Excel II

 

We'll carry on with our further processes, 

Format Selection (cells, objects, charts).

Format Painter – Paste formats from selection.

Hide row.

Hide column.

Unhide row.

Unhide column.

Sets/removes strikeout in current cell.

Show/hide the top bar when you have a group.

Insert hyperlink.

Save as.

Collapse the ribbon (press again to expand).

Maximize the current window.

Activate next window/Activate previous window.

Close an excel workbook.

Split screens.

Create a pivot table in new sheet (of course after selecting the range).

Apply/remove filter.

Keep filter on columns, but show all rows.

Insert pivot table.

Turn filter on or off.

Paste values only.

Insert new sheet.

Insert row.

Delete row.

Enter current date

Enter current time

In this Blog, I covered a long cheat sheet of Excel guess you loved the session...

𝕿𝖍𝖆𝖓𝖐𝖘 & 𝕽𝖊𝖌𝖆𝖗𝖉𝖘...

Share on Facebook Share on Twitter Share on Google Plus

About Freaky Analyst

A Passionate Data analyst working with large amounts of data and to turn this data into information, information into insight and insight into valuable decisions. I also have a keen interest in the field of data analysis, data visualization and am fascinated by the power to compress complex datasets into approachable and appealing graphics.