How to Change Picture Scale Height and Width in Excel with Keyboard Shortcuts
Question details
The user needs to resize a selected picture in an Excel-compatible spreadsheet using only keyboard controls when Alt does not open the Scale settings.
- Product
- WPS Office Spreadsheets (Excel-compatible)
- Device & OS
- not provided
- Scenario
- A picture is selected in an Excel worksheet, and the user wants to change its scale height and width without using the mouse.
- Observed behavior
- Pressing Alt while a picture is selected opens the Home tab instead of the Scale Height or Scale Width settings, so the scale fields cannot be focused directly.
Select the picture in the worksheet and confirm that the Format Picture command is available from the context menu or ribbon. Keep the Format Picture pane open while you move to the Size controls so you do not lose keyboard focus.
Open the Format Picture Pane and Use the Size Controls
Use this method when Alt opens the Home tab instead of the Scale settings. The Format Picture pane gives keyboard-accessible Height and Width fields that update the scale automatically.
The Alt key normally activates ribbon key tips, so it may open the Home tab instead of focusing a picture's Scale Height or Scale Width box. The Format Picture pane provides keyboard-accessible Height and Width inputs that recalculate the scale.
Click the picture in the worksheet that you want to resize, or use the arrow keys to move the selection to the image.
Press Shift+F10 to open the context menu, then choose Format Picture. In WPS Spreadsheets, you can also right-click the picture and click Format Picture.
In the Format Picture pane, use Tab or the arrow keys to select Size & Properties, then move focus to the Height or Width field.
Type the required value in Height or Width and press Enter. The Scale Height and Scale Width fields update automatically.
Change Picture Height and Width by Keyboard in WPS Office Spreadsheets
Use WPS Office Spreadsheets to open the Format Picture pane and adjust Height or Width. The scale fields update automatically, so you can resize images without a mouse and still keep Excel formatting.
- 1. Open the workbook: Launch WPS Office Spreadsheets and open the .xlsx workbook that contains the picture you need to resize.
- 2. Select the picture: Click the picture in the worksheet, or use the Tab or arrow keys to move the selection to the image.
- 3. Open Format Picture: Press Shift+F10 and choose Format Picture, or right-click the picture and select Format Picture.
- 4. Adjust Height or Width: In the Size & Properties section, focus on the Height or Width field and type the new value, then press Enter.
- 5. Save the workbook: Press Ctrl+S to save the workbook so the new picture dimensions and scale are retained.
Frequently Asked Questions
Why does pressing Alt open the Home tab when I have a picture selected?
Alt activates ribbon key tips on the Home tab instead of focusing the picture's Scale Height or Scale Width box. Open the Format Picture pane from the context menu or a shortcut, and use the Size controls there.
What is the fastest keyboard way to open the Format Picture pane?
Select the picture and press Shift+F10 to open the context menu, then choose Format Picture. You can also use Alt and follow the displayed ribbon key tips if a Format tab appears.
Can I change the Scale Height and Width percentages directly?
In many Excel versions the Scale Height and Scale Width boxes cannot be focused directly, but changing Height or Width in the Format Picture pane recalculates the scale percentage automatically.
Does changing Height or Width keep the picture proportions?
If Lock aspect ratio is enabled in the Format Picture pane, changing Height updates Width automatically. If it is off, you can set each dimension independently.
Does WPS Office support the same picture resize workflow?
Yes. WPS Spreadsheets includes a Format Picture pane with Size controls and works with Excel .xlsx picture formatting, so you can use the same resize workflow.
