Advance Excel Keyboard Shortcut #7

-


CTRL + A: Select All

CTRL + B: Bold

CTRL + C: Copy

CTRL + D: Uses the Fill Down command to copy the contents and format of the topmost cell into the selected cells below the cells

CTRL + F: Find

CTRL + G: Screen the Go to dialog box

CTRL + H: Replace

CTRL + I: Italics

CTRL + K: Screen the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks

CTRL + N: Creates a new, blank work box

CTRL + O: Screen the open dialog box to open or find a file

CTRL + P: Displays the print dialog box

CTRL + R: Uses the Fill Right command to copy the content and format of the left side most cell into a selected range

CTRL + S: Saves the active files with its current file name, location and file formats

CTRL + T: Screen display the Create Table dialog box

CTRL + U: Underline

CTRL + V: Paste

CTRL + W: Closes the selected workbook window

CTRL + X: Cut

CTRL: + Y: Repeated the last command or action, if possible

CTRL + Z: Uses the Undo command to reverse the last command or delete the last entry that you typed

CTRL + SHIFT + &: Applies the outline border to selected cells

CTRL + SHIFT + ~: Applies the general number format

CTRL + SHIFT +%: Applies the percentage format with no decimal places

CTRL + 6: Alternates between hiding object, display objects and display placeholder

CTRL + 8: Displays or hides the outline symbol:

CTRL + 9: Hides the selected rows

CTRL + 0: Hides the selected columns

CTRL + ARROW KEY moves the edge of the current data region into a worksheet

SHIFT + ARROW KEY extend the selection of cells of one cell

BACKSPACE: Deletes one character to the left in the formula bar as well as clears the content of the active cell, In cell editing mode, it delete the characters to the left of the insertion points

DELETE: Removes the cell data from selected cells without any affecting cell formats or data in cell editing mode. It is deletes the character to the right of the insertion points.

SHIFT + F2: Edits a cell comment

CTRL + F5: XL, Restore window size

CTRL + F6: Next workbook window

CTRL + SHIFT + F6: Previous workbook window

ALT + F8: Opens macro dialog box

CTRL + F9: To minimize workbook

CTRL + F11: To open VBE

CTRL + SHIFT + F6 : For previous window

CTRL + SHIFT + F1: To open new worksheet

CTRL + 0: To open workbook

CTRL + SHIFT + TAB: To active previous workbook

F4: During formula typing, adjusts the reference type, relative to abs, and repeats last action

CTRL +; /:: Inserts current date

CTRL + /: Copies value from cell above current cell

ALT + / s: Auto sum selected cells and places values in cells beneath

CTRL + SHIFT + $ / 4: Currency formats current cell

CTRL + SHIFT + et / 7: Applies outline border to selected cells

CTRL + SHIFT +: / 1: Comma formats current cell

SHIFT + CTRL + F: Activates font drop list

SHIFT + CTRL + P: Activates font point size drop down list

Comments

Post a Comment

Thanks you
for comment and your suggestion

Popular posts from this blog

Hacker Directory #49

-
Image
  Do you feel dumb when you don't know the meaning of a certain term?  Well, then this will certainly help you out!  If you are ever unsure about anything, simply swipe left and find that specific word, then read the definition.  ABBREVIATIONS DDoS = Distributed Denial of Service DrDoS = Distributed Reflected Denial of Service Attack, uses a list of reflection servers or other methods such as DNS to spoof an attack to look like it's coming from multiple ips.  Amplification of power in the attack COULD occur.  FTP = File Transfer Protocol. Used for transferring files over an FTP server. FUD = Fable Hex = In computer science, hexadecimal base - refers to the number 16. These are the numbers that use the digits in the series: 0123456789ABCDEF. In the C programming language (as well as Java, JavaScript, C and other places), hexagonal numbers are subscribed by a bull. Thus, one can say that the number 0x80 is not equal to 80 decimals but equal to 128...
Read more

Programmer Know about following concept #21

-
Image
1. Caching 2. Time Complexity 3. Networking basics 4. Cloud Computing 5. Data structures and Algorithms 6. Database and SQL 7. Text editors 8. UNIX 9. Programming languages 10. Scripting languages   Explain  : 1. Caching A cache is stores data, that is hardware or software component so that future requests for that data can be served faster. Without cache no modern web system can runs. 2. Time Complexity Time complexity is the computational complexity that   describes the amount of time it takes to run on algorithm. 3. Networking basics You have to understand the basics of how the network in order to be a good programmer. Through switches, routers and wireless access points, devices connected to your network can communicate with one another and with other networks, like internet. Routers, wireless access points and Switches perform very different functions in a network. 4. Cloud Computing It's the on-demand availability of computer system resources, especially data s...
Read more

You are Founder of Software company #20

-
Image
Visual Design: The Goal of visual design is to shape and improve the user experience through considering the effects of illustration typography, space, etc. it is important to note that the visual side needs to comply with the UX design. Having a product that looks good cannot justify poor usability. Tips : Try developing a sense of good design by reading something (example: relevant digests) for 30 min every week to train your perception. you don’t need to have any actual design skill.   Resources: designernews.co Sodebar.io   UX Design: User experience describe all the interaction between customer and a product – From visual on a landing page to support request. Bad user experience designed make people hate your product. Tips : If you are not an expert. Follow establish design patterns and try copy great products design when possible. Those teams spent a lot of resources on experiments to improve their UX design, so it ...
Read more