Mastering Photoshop: Essential Shortcuts Every Designer Should Know

While there are many keyboard shortcuts in Adobe Photoshop, I can provide you with a list of 100 commonly used ones. These shortcuts are based on the version of Photoshop available as of my knowledge. Keep in mind that some of these shortcuts may vary depending on your version of Photoshop or your operating system. Here's the list:

General Shortcuts:

• Ctrl + N - New document
• Ctrl + O - Open file
• Ctrl + S - Save
• Ctrl + Shift + S - Save As
• Ctrl + W - Close file
• Ctrl + Q - Quit Photoshop
• Ctrl + Z - Undo
• Ctrl + Shift + Z - Redo
• Ctrl + X - Cut
• Ctrl + C - Copy
• Ctrl + V - Paste
• Ctrl + A - Select All
• Ctrl + D - Deselect
• Ctrl + T - Free Transform
• Ctrl + 0 - Fit to Screen
• Ctrl + 1 - 100% View
• Ctrl + + - Zoom In
• Ctrl + - - Zoom Out
• Spacebar - Hand tool (temporary)
• Ctrl + Spacebar - Zoom In (temporary)
• Alt + Spacebar - Zoom Out (temporary)
• F - Toggle full-screen mode

File Handling:

• Ctrl + Alt + Shift + N - New layer
• Ctrl + J - Duplicate layer
• Ctrl + E - Merge selected layers
• Ctrl + G - Group layers
• Ctrl + Shift + G - Ungroup layers
• Ctrl + / - Toggle layer visibility
• Ctrl + ] - Bring layer forward
• Ctrl + [ - Send layer backward

Selections:

• M - Marquee tool
• L - Lasso tool
• W - Wand tool
• Ctrl + Shift + I - Invert selection
• Ctrl + Shift + D - Deselect
• Ctrl + Shift + A - Reselect
• Q - Quick Mask mode
• Ctrl + Alt + R - Refine Edge
• Ctrl + Shift + J - New layer via copy
• Ctrl + Shift + X - New layer via cut

Brush and Painting:

• B - Brush tool
• E - Eraser tool
• Alt + Delete - Fill with foreground color
• Ctrl + Delete - Fill with background color
• D - Reset to default colors (black and white)
• X - Swap foreground and background colors
• Shift + [ - Decrease brush size
• Shift + ] - Increase brush size
• Shift + B - Cycle through brush tools
• [ - Decrease brush hardness
• ] - Increase brush hardness

Navigation and Views:

• H - Hand tool
• I - Eyedropper tool
• R - Rotate view tool
• Ctrl + 0 - Fit to Screen
• Ctrl + 1 - 100% View
• Ctrl + + - Zoom In
• Ctrl + - - Zoom Out
• Ctrl + Alt + 0 - Actual Pixels
• Spacebar + Ctrl - Temporarily switch to Hand tool
• Ctrl + Spacebar - Zoom In (temporary)
• Alt + Spacebar - Zoom Out (temporary)

Layers and Masking:

• Ctrl + Alt + Shift + E - Merge visible layers to a new layer
• Ctrl + Shift + N - New layer
• Ctrl + Alt + G - Create clipping mask
• Ctrl + Alt + E - Merge visible layers
• Ctrl + Alt + Shift + K - Flatten image
• Ctrl + L - Adjust levels
• Ctrl + M - Adjust curves
• Ctrl + B - Adjust color balance
• Ctrl + U - Adjust hue/saturation
• Ctrl + G - Create a group
• Ctrl + Shift + G - Ungroup
• Ctrl + / - Toggle layer visibility
• Ctrl + Alt + / - Toggle layer mask
• Ctrl + E - Merge selected layers

Text and Type:

• T - Text tool
• Ctrl + T - Free Transform text
• Ctrl + Enter - Commit text
• Ctrl + A - Select all text
• Ctrl + D - Deselect text
• Ctrl + H - Hide text bounding box
• Ctrl + Shift + > - Increase text size
• Ctrl + Shift + < - Decrease text size
• Ctrl + Alt + C - Character panel
• Ctrl + Alt + T - Transform text
• Ctrl + ] - Increase baseline shift
• Ctrl + [ - Decrease baseline shift

Filters and Effects:

• Ctrl + F - Apply last filter
• Ctrl + Alt + F - Apply last filter to a new layer
• Ctrl + U - Adjust Hue/Saturation
• Ctrl + L - Adjust Levels
• Ctrl + M - Adjust Curves
• Ctrl + B - Adjust Color Balance
• Ctrl + Alt + Shift + E - Merge all visible layers to a new layer

Miscellaneous:

• Ctrl + Shift + K - Crop tool
• Ctrl + Alt + Shift + S - Save for Web
• Ctrl + Alt + I - Image size
• Ctrl + Alt + C - Canvas size
• Ctrl + Alt + Shift + T - Transform again

Please note that these shortcuts are for Windows. If you are using a Mac, replace "Ctrl" with "Command" (⌘) and "Alt" with "Option." Also, Photoshop may have received updates since my last knowledge, so there may be new shortcuts or changes to existing ones in the latest versions.

Mastering Excel: 100 Essential Shortcut Keys for Increased Productivity

Excel shortcut keys are a great way to increase your productivity and efficiency when working with spreadsheets. Here's a list of 100 Excel shortcut keys that can help you perform various tasks quickly:

Navigation and Selection:

1. Ctrl + Arrow Keys: Navigate to the edge of data regions.
2. Ctrl + Space: Select the entire column.
3. Shift + Space: Select the entire row.
4. Ctrl + A: Select the entire worksheet.
5. Ctrl + Shift + L: Toggle filters on/off.
6. Ctrl + F: Open the Find dialog box.
7. Ctrl + H: Open the Replace dialog box.
8. Ctrl + G: Go to a specific cell.
9. Ctrl + Page Up/Page Down: Switch between worksheets.
10. Ctrl + Home: Go to cell A1.

Editing:

1. F2: Edit the active cell.
2. Ctrl + Z: Undo.
3. Ctrl + Y: Redo.
4. Ctrl + C: Copy.
5. Ctrl + X: Cut.
6. Ctrl + V: Paste.
7. Ctrl + Alt + V: Paste Special.
8. Ctrl + D: Fill down.
9. Ctrl + R: Fill right.
10. Ctrl + - (Minus key): Delete selected rows or columns.

Formatting: 

1. Ctrl + B: Bold.
2. Ctrl + I: Italic.
3. Ctrl + U: Underline.
4. Ctrl + 1: Format cells dialog.
5. Ctrl + 5: Strikethrough.
6. Ctrl + Shift + L: Apply or remove filters.
7. Ctrl + Shift + + (Plus key): Insert new row/column.
8. Ctrl + 1: Format Cells dialog box.
9. Ctrl + 9: Hide rows.
10. Ctrl + 0: Hide columns.

Workbook and Worksheet Management:

1. Ctrl + N: New workbook.
2. Ctrl + O: Open workbook.
3. Ctrl + S: Save workbook.
4. Ctrl + P: Print workbook.
5. Ctrl + W: Close workbook.
6. Alt + E, S, V: Paste special values.
7. Alt + E, S, T: Paste special transpose.
8. Ctrl + Tab: Switch between open workbooks.
9. Ctrl + Page Up/Page Down: Navigate worksheets.
10. Alt + Page Up/Page Down: Move between worksheet tabs.

Formula and Function:

1. Alt + = (Equal key): AutoSum.
2. Ctrl + ` (Backquote key): Show/hide formulas.
3. F9: Calculate worksheets.
4. Shift + F3: Insert function.
5. Ctrl + Shift + Enter: Enter an array formula.
6. Ctrl + ` (Backquote key): Show/hide formulas.
7. F4: Repeat last action.
8. Alt + Enter: Start a new line in a cell.
9. F9: Recalculate all worksheets.
10. Alt + F8: Open the Macro dialog box.

Data Entry:

1. Alt + Down Arrow: Display auto-complete list.
2. Ctrl + ; (Semicolon): Enter current date.
3. Ctrl + Shift + ; (Semicolon): Enter current time.
4. Ctrl + Shift + ": Copy value from cell above.
5. Ctrl + ' (Apostrophe key): Copy formula from cell above.
6. Alt + Enter: Start a new line in a cell.
7. Ctrl + Space: Select the entire column.
8. Shift + Space: Select the entire row.
9. Ctrl + Shift + + (Plus key): Insert new row/column.
10. Ctrl + - (Minus key): Delete selected rows or columns.

View and Zoom:

1. Alt + W, F: Freeze panes.
2. Ctrl + F1: Show/hide ribbon.
3. Ctrl + 0 (Zero key): Hide selected columns.
4. Ctrl + 9: Hide selected rows.
5. Alt + W, V: Split window.
6. Ctrl + F6: Switch between open workbooks.
7. Ctrl + Page Up/Page Down: Switch worksheets.
8. Ctrl + Mouse Wheel: Zoom in/out.
9. Alt + H, O, I: AutoFit column width.
10. Alt + H, O, A: AutoFit row height.

Miscellaneous:

1. Alt + Enter: Start a new line in a cell.
2. Ctrl + K: Insert hyperlink.
3. Alt + Space: Open the window control menu.
4. F12: Save As.
5. Ctrl + F5: Restore window size.
6. Alt + F4: Close Excel.
7. Ctrl + F1: Hide/show ribbon.
8. F6: Switch between cells, worksheet, and ribbon.
9. Ctrl + F2: Print Preview.
10. Ctrl + Arrow Keys: Navigate within data.

These shortcut keys can significantly speed up your Excel tasks, whether you're entering data, formatting cells, or working with formulas. Practice using them to become more proficient in Excel.