Yesterday when I was editing an Excel 2007 file, I tried to add a new line, but it failed every time. Excel said “Cannot shif objects off sheet”, as shown in the figure below.
The simplest solution is to press
Ctrl+6, you can’t add new lines again. The specific reasons can be found in the following links:
http://office.microsoft.com/en-us/excel/HA102412411033.aspx
Reproduced in: https://blog.51cto.com/jackiechen/281830
Read More:
- To solve the problem of C # calling excel interface error, prompt: the COM object of Microsoft. Office. Interop. Excel. Applicationclass is forcibly converted to the interface type “Microsoft. Offi”
- Solutions to problems in SAS 9.3 x64 importing and exporting Excel
- [Python] pandas Library pd.to_ Parameter arrangement and example of Excel operation writing into excel file
- XLRDError: Excel xlsx file； Not supported error reporting solutions
- Tensorflow image random_ There seems to be something wrong with the shift function
- There was a problem sending the command to the program in Excel 2010
- Python selenium — webriver cheat sheet
- How to Disable Protected View in Microsoft Excel
- Read multiple sheets of an excel file according to npoi
- How to turn off merge request in gitlab
- Solution to the problem that SQL database query result field contains new line character, which leads to copy to excel dislocation
- Swap off failed: cannot allocate memory
- Call Excel to report an error (the exception comes from HResult: 0x80010105 (RPC)_ SERVERFAULT))
- How to Use the object of ES6 to clear the object value
- Solution of off grid pin in Ad
- Off line data storage and upload scheme
- Server configuration excel export HResult: 0x800A03EC
- Linux turn off enable firewall command
- On and off of timer in JS
- The built-in filter function in Excel can’t contain all the items