Excel - MrExcel Mailbag: Episode 1448
888 views · Published 13 October 2011 · 3:48 · Indexed 28 October 2026
Channel: MrExcel.com · 2011 · Education
Microsoft Excel Tutorial: Excel Mailbag: Solving Common Issues and Tips | MrExcel Podcast. Welcome to the MrExcel Podcast. In this episode, we dive into the mailbag to answer some of your burning Excel questions. I'm your host, Bill Jelen, and I'm excited to catch up on a few things that have been on our viewers' minds over the past couple of weeks. In Episode 1437, we discussed a common issue where one person with a small monitor couldn't see the entire spreadsheet while another person with a larger monitor could. I shared a macro that could help with this problem, but it turns out there's an even easier solution. By going to View, then Arrange All, you can bring any hidden parts of the spreadsheet back into view. Thanks to our viewers for sharing this helpful tip! Last week, we talked about the frustration of not being able to find the Center Across Selection option in the ribbon. A viewer pointed out that it can easily be added as a one-line macro and placed in the Quick Access Toolbar. Simply go to Macros, select Center Across, and add it to the toolbar. Now, you can easily center text across multiple cells without having to go through the Format Cells menu. Another viewer, Jim, reminded us of a feature that used to be available in older versions of Excel. By double-clicking on the bottom, left, top, or right edge of a cell, you can quickly move to the edge of the data without filling. This is a great alternative for those who prefer using the mouse over keyboard shortcuts. Plus, it even scrolls the data into view, making it more efficient than using the Ctrl + arrow keys. Thank you for tuning in to this episode of the MrExcel Podcast. I hope these tips and tricks have been helpful for you. Don't forget to subscribe to our channel and hit the notification bell to stay updated on all our latest episodes. See you next time for more Excel insights and solutions. Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Issue with Spreadsheet on Different Monitors (00:15) Solution: View Arrange All (00:25) Center Across Selection Generates Email (00:50) One-Line Macro Solution (01:00) Adding Macro to Quick Access Toolbar (02:01) Finding the Center Across Selection Icon (02:35) Another Tip from a Viewer (03:28) Double-Clicking to Move to Edge of Data (03:38) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Adding macros to quick access toolbar Center Across Selection in Excel Episode 1448 - Mailbag Excel 95 features and icons Excel tips and tricks Keyboard shortcuts vs mouse techniques Macro for moving spreadsheet view Merge and center vs Center Across Selection Moving to edge of data without filling Spreadsheet display issue Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153126/ Today, in Episode #1448, Bill re-addresses a few past podcasts with alternate solutions. 1. A Non-VBA Solution to get Misplaced Excel Windows back into view (improving upon Episode #1437). 2. A VBA Solution to Center Across Selection (as discussed in Episode #1443). 3. A Mouse Click Solution to move to the Edge of your Data quickly. ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920