On May 19, 10:36 pm, qrjhaik
wrote:
Using Excel SP3. Would like to paste-special-all. However, it always pasted
with a standard format e.g. the standard width, standard height . Is there
any setting for that? Pls kindly assist.

What do you mean by "all"? Paste Special is there so you can paste
only a part. "All" suggests you simply want Paste, not Paste Special.
Usually all you have to do is hit Enter to paste in Excel.

If you want row or column sizes to copy/paste, you have to copy/paste
the entire row or column.

If you want to copy/paste an entire worksheet complete with row and
column sizes, you can either right-click the tab and select Move or
Copy (this will also include Print settings), or you can click on the
little rectangle where the row and column headers meet, then copy,
then do a normal Paste in the new sheet (this will not include Print
settings).