How to Reuse the Last Border Style in Excel: Troubleshooting Guide
Question details
Users need a way to quickly apply the most recently used cell border style because it no longer appears as the first quick-select option in the right-click menu.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Formatting multiple cells or ranges repeatedly with the same specific border style, such as a double bottom border.
- Observed behavior
- The right-click context menu and mini-toolbar in Excel no longer retain the last-used border style for quick reuse, forcing users to navigate through the full borders menu repeatedly.
Ensure you have selected the exact cell or range of cells where you want to apply the new border. Familiarize yourself with the Home ribbon, as we will use it for quicker repetitive formatting.
Use the Borders Dropdown on the Home Ribbon
The Borders button on the main Home ribbon still remembers the last border applied during your current session, making it a reliable alternative to the right-click menu.
While the right-click context menu has changed in recent Excel updates, the primary ribbon retains its classic behavior. By using the main toolbar, you can bypass the missing right-click option.
Highlight the first cell or range of cells where you want to apply the specific border style.
Navigate to the 'Home' tab. In the 'Font' group, click the small dropdown arrow next to the 'Borders' icon and select your desired style (e.g., Bottom Double Border).
Select the next cell or range. Instead of opening the dropdown menu again, simply click the main 'Borders' icon directly. It will instantly apply the last style you selected.
Apply Formatting Repeatedly using Format Painter
If you need to apply the exact same border and associated cell formatting to multiple non-adjacent cells, the Format Painter tool is highly efficient.
Submit Feedback to Microsoft
Since the feature appears to have been removed or altered by Microsoft, submitting direct feedback is the best way to request its restoration.
Easily Manage and Reuse Cell Borders in WPS Spreadsheet
WPS Office provides a highly reliable classic interface where your preferred formatting tools are easily accessible. You can effortlessly apply and reuse cell borders without worrying about sudden UI changes hiding your favorite tools.
- 1. Open your file in WPS: Launch WPS Spreadsheet and open your existing .xlsx workbook.
- 2. Select the cells: Highlight the cells you wish to format.
- 3. Apply a border: Navigate to the Home tab, locate the Borders dropdown icon, and select your preferred border.
- 4. Reuse with one click: The selected border style remains on the main toolbar button for immediate one-click reuse on subsequent cells.
Frequently Asked Questions
Is there a keyboard shortcut to apply the last used border in Excel?
Excel does not have a dedicated shortcut solely for the 'last used' border. However, if you just applied a border, you can select a new cell and press the 'F4' key to repeat your last action, which will apply the same border.
Why did my right-click menu stop showing the last border style?
Microsoft regularly updates the Office interface. Recent software updates to the right-click context menu (and the attached mini-toolbar) changed how recently used tools are cached, which resulted in the dynamic last-border option being removed for many users.
How can I quickly apply a double bottom border to multiple cells?
Go to the Home tab, click the arrow next to the Borders button in the Font group, and select 'Bottom Double Border'. After this initial selection, the main icon changes to the double border, allowing you to just click the main button for subsequent cells.
Can I customize the quick access toolbar to include specific borders?
Yes. You can click the down arrow on the Quick Access Toolbar (top left of the screen), select 'More Commands', and add specific border tools (like 'Bottom Double Border') directly to the toolbar for permanent, one-click access.
