Home  >  Article  >  Topics  >  Excel implements mirror reversal

Excel implements mirror reversal

藏色散人
藏色散人Original
2020-02-14 11:07:0410085browse

Excel implements mirror reversal

Excel implements mirror reversal

Excel implements mirror reversal

Tool Options International Check the current worksheet from right to left to confirm

or

Enter or copy and paste the following formula in G1

=IF(COLUMN(A1)<=COUNT($A1:$E1),INDEX($A1:$E1,COUNT($A1:$E1)+1-COLUMN(A1)),"")

Pull right to fill, drop down to fill

Excel implements mirror reversal

Please add a detailed explanation

For more Excel-related technical articles, please visit the Excel Basic Tutorial column!

The above is the detailed content of Excel implements mirror reversal. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn