Excel Tips, Tricks, and Shortcuts

Discover simple tips, tricks, and shortcuts to help you manage Excel more easily and boost your productivity.

Search This Blog

Posts

Showing posts with the label Ctrl + ' (apostrophe)

Show all

No results found

Subscribe

Posts

Atom

Posts

All Comments

Atom

All Comments

[Solved] Turn Off / Turn On Scroll Lock Excel Tip To Lock and Unlock On Keyboard | Exceltip2day Blog

June 28, 2013

Hello friends. I'm Michael. Welcome everyone to in my blog "Exceltip2day" , The tip for today is: " How to unlock the Scroll Lock" Tip Quiz Do you know what is the shortcut key(s) to Redo Last Action (Multiple Levels) in an Excel spreadsheet? Check the way [Turn Off] / [Turn On] - Scroll Lock down here. Excel worksheet, you may touch it accidentally a [Scroll Lock] button. This would lock cursor stuck on the current cell. To undo it, do one of the following: i] Press the Scroll Lock / ScrLk key on your keyboard. Alternatively, if some keyboard does not have a Scroll Lock key, such as Notebook, Tablet and some other kind of PC. Just follow the step by step. ii] (Window 7) Go to -Start, -All Programs, -Accessories, -Ease of Access, -Then, just click on the " On-Screen Keyboard " line. When the "On-Screen Keyboard" appears on your screen, click the ScrLK button as shown on ( In red round rectangle ) the image be...

Get link
Facebook
X
Pinterest
Email
Other Apps

1 comment

Page Down Excel Keyboard Key Button For Moving Down Page Screen One By One | Exceltip2day

April 08, 2013

Hello there. I'm Michael, welcome you to my blog. Today I'm going to talk about: The 2 ways of moving Excel's screen down. My article consists of how to move the screen of the current spreadsheet you are working on it with the keyboard. Instead of using a scroll down with a mouse, using the button "PAGE DOWN" keyboard seems more comfortable way. Tab: Learn Pure Thai FB Tab: E n Numbers In Words By the way, you can choose which one is fit for you. Ctrl+0(Zero) Excel Shortcut Key To Hide The Selected Column | ExcelTip2Day Tip Quiz What is the shortcut to close your an Excel workbook instantly? Let's come to the point. Just in case wanting to move the active Excel spreadsheet goes down the page by page. There are two ways to manage it. 👉 1st method: Using the scroll wheel On your mouse to scroll the worksheet up and down. To roll back or roll into users, the page will move up. On the other hand, to...

Get link
Facebook
X
Pinterest
Email
Other Apps

Labels

“A Keystroke”
"Excel shortcuts
[Alt] + [Space Bar]
[Concatenate]
[Ctrl + End]
[Ctrl + N]
[Ctrl + Space bar]
[Ctrl + X]
[Ctrl] [Arrow Left]
[Ctrl] [F9]

[Ctrl] + [-](Minus button)
[Ctrl] + [Arrow Right]
[Ctrl] + [P]
[Ctrl] + [Tab]
[Ctrl] + [Z]
[Ctrl]+[Arrow Keys]
[Ctrl]+[Delete]
[Ctrl]+[Shift]+[Page Up]
[Ctrl]+[Shift]+[Tab]
[Ctrl]+[Tab]
[Ctrl+G]
[Ctrl+Page Down]/[Ctrl+Page Up]
[Ctrl+Shift+O(letter)]
[F11]
[F12]
[F8]
[Shift]+[Arrow Keys]
[Shift+Ctrl+End]
[Tab] / [Shift]+[Tab]
=count(xx:xx)
=TODAY()
2 [Arrow Key] move diagonally
3 Tricks To Zoom In and Zoom Out
4 Arrow Keys
4 Cool Ways To “Sum” Values
89 shortcut keys begin Ctrl+Etc
9 Easy-to-Understand Vlook up
Align Number To Be At The Center
Alt+F11
Alt+F4
Apply border on
Auto-Fill Out Respective Data
automatic dates
Average
Averageif Exclude "0"
AVERAGEIF Formula Not Including “0” (Zero) In Range
Beginner Excel Tutorial
Calculate active cells the number(s)
Change number far right to far left
Closing Active Document That Open Simultaneously
combine data
copy and paste immediately
Create And Insert Excel Chart
Create New Excel Blank WorkBook
Ctrl + ' (apostrophe)
Ctrl + C
Ctrl + F3
Ctrl + Home
Ctrl + V
Ctrl Shift Asterisk
Ctrl+-
Ctrl+; Shortcut Excel To Insert The Current Date.
Ctrl+"
Ctrl+0(Zero)
Ctrl+A
Ctrl+F
Ctrl+F1
Ctrl+F10
Ctrl+F4
Ctrl+H
Ctrl+S
Ctrl+Shift+_
Ctrl+Shift+&
Ctrl+Shift+Home
Ctrl+Shift+Page Down
Ctrl+Y
Ctrl+Z
CURRENT DATE
Cut The Selected Data
Delete The Last Entered Data Entry
Delete the same data in multiple places
Delete Unwanted Characters From The Left Side
deleting excel multiple worksheets
Display Data On The Left Of Pivot Table
Display Name Manager Dialog Box
Display The “Save As” Function Fastest
dynamic dates
Edit The Active Cell and Position the the point At The End With Cursor
Erase Lines Border Of
Escape Away From Header And Footer To Normal View
Excel
Excel 4 Aspects Deleting with ctrl+-
Excel Formulas
Excel Functions
Excel IF Function
Excel Problems
Excel Shortcut Ctrl + . Move Clockwise
Excel Shortcut Key To Hide The Selected Columns
Excel Shortcuts
Excel Tips
Excel Tips and Tricks
Excel TODAY function
Excel tricks
Excel Troubleshooting
Excel VLOOKUP
Exceltip2day Blog
Expand column width
Extend Selection Cell To Last Used Cell
Extract characters end content
Extract Specified Characters From The Left
F2
Find specific data
Fix workbook contains links "This Workbook Contains Links To Other Data Sources"
Format Painter
Formulas
function =NOW()
Functions
gathering data
Go To Cell "A1" Of The Current Spreadsheet
Home
How to display the Find and Replace dialog box
How To Fill Cell Formulas Down From The Adjacent Cell Above
how to get current date and time (varies) in Excel
How to select the entire column
How To Use "Select Object"
Insert New Worksheet into Current Workbook
Instantly Copy "Data Entered"
Instantly Paste "Data Entered"
Keyboard Issues
Keyboard Key "FIND and REPLACE"
left
LOOK UP - Array Form
LOOK UP Approximate Match
Make Graph with “REPT ( )” Formula
make space between data
Microsoft Excel
Microsoft Excel Guide
Microsoft Excel Shortcut Key for Call Out "Insert Function" Dialog Box Instantly
Minimize / Restore the Ribbon Bar
minimize window(s)
minimize workbook
Minimize/Restore workbook window
Move down Excel worksheet screen one by one
Move to the beginning of a cell data entry
Move To The Beginning Of A Row In A Worksheet
Moving Up Screen One By One
Office 365
Open Dialog Box Menu of Delete Cells/Row and Column
Page Down
Page Up
paste entire column
Productivity
productivity hacks"
Quick paste data to multiple cells
Reduce Size Excel File
Removes right characters in cell
Removes Unwanted Spaces
Resolve "0" number disappear
Screen upside down solving tip
Scroll Lock
Searches Value From Table Array In The First Column
Seek Out The "Go To" Dialog Box
seek the "Last Find"
Select All Active Cells Insert Comment
select all cells in range
select column(s)
Select Copy Delete Format Data Entered Between Range Of Cells
Selecting All Active Cells In A Range
SharePoint
Shift + Space Bar
Shift+F11
Shift+F3
Shift+F4
Shortcut begin ALT+Etc.
shortcut closing Excel workbook
Shortcut key save current Excel file
Shortcut keys fixing monitor screen accidentally 'Upside Down'
shortcut printing order
Shortcut To Open Visual Basic Editor To Create Macro
Single Click Format The Entire Cells In A Workbook
Switch To The Next Tab In Dialog Box
Time-Saving Shortcuts
to redo last action (Multiple levels) Excel shortcut Key
To select the current region around the active cells.
To Select The Entire Row of Excel Worksheet
Trick - Double Click Auto-Adding Data
Trim(text)
Troubleshooting
Turn Off Scroll Lock
Turn On Scroll Lock
undo last action in Excel worksheet
Undo the Last Action
Unlimited Multiple Paste
VLOOKUP
Windows tricks

Show more Show less

Report Abuse

📢 Hello, friends! My name is Michael. I’m Thai, working as a logistics assistant, lawyer and a freelance blogger. I’m passionate about sharing my knowledge of Microsoft Excel to help others work smarter and faster. I believe that learning even a little can make a big difference, so I’m here to share simple tips, shortcuts, and tricks for anyone who wants to improve their Excel skills. ✅ Your feedback is always welcome—I’m constantly looking for ways to improve this blog and make it more useful for you. ✅ Please note: This blog may contain affiliate links to support my work. Thank you so much for visiting! Michael Leng

Learn Thai Free Online [LTFO] | Michael Leng

🥣 How to Say “No One Should Be Hungry” in Thai พูดยังไงดีว่า “ไม่ควรมีใครต้องหิว” เป็นภาษาไทย
Bilingual Lyrics : English - Thai

🎵-เจาะลึกความหมาย! แปลเพลง "Priceless" ของ Maroon 5 (feat. LISA) พร้อมวิเคราะห์ทุกท่อน
Book-Hub | Best Seller Books Review

[[The Girl on the Train]] Is Written by Paula Hawkins as Extremely Exciting Genre | Book-Hub Review

Posts

Atom

Posts

All Comments

Atom

All Comments

Powered by Blogger