The issue stems from Excel's clipboard behavior, which includes hidden intervening columns when copying non-adjacent selections. A simple workaround is to use Excel's "Go To Special" dialog: press F5, click "Special", select "Visible cells only", and then copy. This will ensure only your selected columns are placed on the clipboard for pd.read_clipboard() to read correctly.